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 “crouse” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
crouse8461936(None) 
arouse65019981arouse
carouse9614421carouse
chouse116017561chouse
crosse85216301crosse
croupe105114431croupe
croute84617271croute
cruse75726101cr_use
grouse74315021grouse
rouse56634701_rouse
arose55832082aro_se
aroused84914342aroused
arouser74514422arouser
arouses74921292arouses
blouse84714722blouse
bouse75931852_bouse
brose75227032bro_se
browse115713852browse
caroused1149252caroused
carousel1057312carousel
carouser1068842carouser
carouses10614502carouses
cause75225352c_ause
cayuse11207762cayuse
cerous85821202cerous_
ceruse83914522ceruse
choose115116142choose
chose105925402cho_se
choused135012462choused
chouser125212942chouser
chouses125117812chouses
choush14549062choush
chowse144711752chowse
clause84311502clause
close76425222clo_se
copse95623922c_opse
corpse104013402corpse
corse75036182c_orse
coude85022632c_oude
coupe96023482c_oupe
course85117782c_ourse
crease85519572crease
creese84014332creese
crocs95722432crocs_
crocus104813172crocus_
crocuses1239022crocuses
crone75231332cro_ne
crones84729242crones
crops96125232crops_
crore74922872cro_re
crores86121162crores
cross75124502cro_ss
crossed105313892crossed
crosser95015462crosser
crosses94220792crosses
crouch133910202crouch
croup95616782crou_p
croupes114613102croupes
croups104312552croups
croupy13458732croupy
crousely1346562crousely
croutes94815652croutes
crows105727312crows_
croze164719452cro_ze
crozes174417662crozes
crude86018572cr_ude
cruise84314042cruise
crus65828482cr_us_
cruses88127712cr_uses
cruset84425092cr_uset
crush106815992cr_ush
crust75827662cr_ust
douse66329722_douse
drowse105010552drowse
druse64817662dr_use
erose55727272ero_se
groused94712832groused
grouser84513692grouser
grouses84616542grouses
house89131422_house
louse56131012_louse
mouse77133002_mouse
profuse1237152profuse
prose75835122pro_se
reuse56025362_reuse
roose56127092_roose
rose46148902_ro_se
roue45941742_rou_e
roues56039352_roues
rouge65423442_rouge
roused75426442_roused
rouser65224082_rouser
rouses65436282_rouses
roust55532062_roust
route55132072_route
ruse45938932_r_use
scouse84113632scouse
scrouge1036352scrouge
souse56530772_souse
spouse84112512spouse
touse55430672_touse
troupe84812432troupe
trouser73812472trouser
uprouse937222uprouse
youse85322232_youse

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511052.18637763.5
3Display Results1051050.0303500.0
 (SQL Overall)1786911052.55969828.4
 
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.