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 “caveators” 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.

73 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
caveators149726(None) 
caveator1387231caveator_
aviators11169902_aviators
caveats1239802caveat__s
cavettos1344972cavetto_s
creators102814412c_reators
abators94413093_a_bators
abettors1056133_abettors
ablators1069883_ablators
accentors13116053accentors
acceptors15114793acceptors
actuators1146443actuators
aerators8315613_aerators
aleatory1148823_aleatory
avatars1036443_av_atars
averters11249513_averters
aviator10229663_aviator_
avigators13177093_avigators
barrators1148393barrators
cabestros1343873cabestros
canephors1644763canephors
cantors94620753ca__ntors
captors113914983ca__ptors
caseates10313713caseat_es
caseations1258303caseations
castors94919443ca__stors
castrators1247443castrators
caveat11417723caveat___
caveated1439133caveat_ed
caveating1539293caveating
cavernous1444563cavernous
cavers115026843cave___rs
cavetto1245453cavetto__
caviars1238623cavia__rs
cavorters1434973cavorters
cheaters133613513c_heaters
chelators1448163chelators
citators10310253c_itators
cocreators1447143cocreators
codebtors1444403codebtors
collators11410343collators
convectors1768313convectors
convertors1549133convertors
covenantors1662623covenantors
coveters132411083cove_ters
covetous1347093cove_tous
crabeaters1444503crabeaters
creator93714443c_reator_
cremators1369823cremators
curators10311723c_urators
deviators1358533deviators
elevators1246303elevators
evertors1138953_evertors
excavators2243543excav_ators
inventors12288253inventors
invertors12239793invertors
investors12227723investors
laudators1045893laudators
lavatory1445703lav_atory
levators11249283lev_ators
macerators14167483macerators
mandators1247873mandators
narrators947863narrators
navigators1464823navigators
obviators1444843obviators
palpators1346803palpators
patentors1146743patentors
radiators1049323radiators
revelators13116423revelators
valuators1286473valuators
vavasors14153653vav_asors
vectors123212593__vectors
viators102712023__viators

Search took 9 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.436409841.7
2DLD Change Limit148641737.97018650.1
3Display Results73730.0302433.3
 (SQL Overall)178691738.43621182.0
 
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.