Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “canoeists” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

54 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
canoeists114716(None) 
canoeist10310691canoeist_
canonists1158511canonists
canonises11410802canonises
canonist10513532canonist_
ableists1036543_ableists
ageists848493_a_geists
agonists9289833_agonists
amorists10411333_amorists
animists103010633_animists
anoints7311063_ano_ints
aorists74215833_a_orists
atheists1138713_atheists
atomists102610963_atomists
banjoists1843253banjoists
cabalists1339153cabalists
cambists1437023ca_mbists
camorrists1443723camorrists
canalises11515493canalises
canniest10313363canniest_
canoeing11310213canoei_ng
canoers94318373canoe__rs
canoes84725883canoe___s
canoness1039393canones_s
canonesses1238423canonesses
canonise10511093canonis_e
canonised1256713canonised
canonizes2049593canonizes
canopies12311853canopi_es
capoeiras1343183capoeiras
careerists1245133careerists
casteisms1345253casteisms
casuists1036523ca_suists
centrists11410233centrists
cineasts1045543cin_easts
coexists1735653c__oexists
colonists112512503colonists
colorists112313593colorists
conceits122813613concei_ts
congests113510383conge_sts
consists10310593con_sists
contests103413383conte_sts
crayonists1544133crayonists
economists1446953economists
gnomists1145473_gnomists
handlists1347133handlists
mannerists1245933mannerists
monodists1247703monodists
panelists1148343panelists
pantheists1546123pantheists
parodists1248513parodists
sarodists1056593sarodists
tanists7313653tan__ists
tenorists948193tenorists

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.406440125.6
2DLD Change Limit148641547.04621095.8
3Display Results54540.0301800.0
 (SQL Overall)178691547.48223882.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.