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

63 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
caestuses114489(None) 
cestuses1038081c_estuses
cactuses1237932ca_ctuses
caestus947772caestu__s
cistuses1038282c_istuses
asbestuses1252173asbestuses
caesiums1245533caesiu_ms
caesuras1055733caes_uras
calentures1244603calentures
callouses1147683callouses
calluses1039323ca_lluses
campuses1437773ca_mpuses
capstones1347373capstones
capsules1236623caps_ules
captures1239443ca_ptures
caresses10314063cares__ses
caritases1139743caritases
caroluses1157613caroluses
carouses10614503ca_rouses
caseases10410473ca_seases
caseoses1039293ca_seoses
casettes1039653caset_tes
casques18278983ca_squ_es
cassises103811743ca_ssises
castes85631863ca_st__es
castles94917733ca_st_les
cathouses1439433cathouses
caucuses1236783ca_ucuses
causes88026473ca___uses
cayuses12188403ca__yuses
censuses10187543c_ensuses
centeses1079443c_enteses
cereuses1049243c_ereuses
ceruses93716233c_e_ruses
cesses84221363c_es__ses
cestodes1138203c_estodes
cestus84412913c_estu__s
chastises1437703chastises
chesses124112633ches__ses
coituses1039623c_oituses
contuses10413453c_ontuses
costumes1258013c_ostumes
creatures1138413creatures
cresses94219813cres__ses
crestless1146783crestless
cultuses1037753c_ultuses
cuscuses1235863c_uscuses
danseuses1044133danseuses
diestruses1164503diestruses
estruses838483__estruses
fetuses10310243_fe_tuses
foetuses1136083foe_tuses
gestures9310013_gestures
halituses1245573halituses
maestosos1142513maestosos
masseuses1144793masseuses
meatuses1038203_meatuses
oestruses946403_oestruses
passuses1036773pa_ssuses
pastises103616053pa_stises
pastures10311963pa_stures
rhesuses1134893rhes_uses
vestures11311043_vestures

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.423422437.4
2DLD Change Limit148641636.73322076.5
3Display Results63630.0163937.5
 (SQL Overall)178691637.17224915.1
 
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.