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

49 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
scrounge114391(None) 
scrouge1036351scrou_ge
scrounged1343131scrounged
scrounger1243441scrounger
scrounges1243921scrounges
scroungy1452561scroungy
scourge1035652sc_ourge
scrooge1037172scro_oge
scrouged1235372scrou_ged
scrouges1136682scrou_ges
scroungers1343182scroungers
scroungier1341962scroungier
conge85227593_c_o_nge
cringe93515483_cr_inge
crone75231333_cro_n_e
croupe105114433_crou_pe
crouse84619363_crou_se
croute84617273_crou_te
frounce1236153_frounce
grunge8359583_gr_unge
lounge75211213__lounge
rouge65423443__rou_ge
sarong73914873saro_ng_
sarongs84511803saro_ngs
scavenge1442813scavenge
sconce104711723sc_o_nce
scone74621833sc_o_n_e
scoring103117213scoring_
scourged1234573sc_ourged
scourger1134723sc_ourger
scourges1136533sc_ourges
scouse84113633sc_ou_se
scroggy14243843scro_ggy
scrooges1137163scro_oges
scrouging1335263scrouging_
scroungiest1442443scroungiest
scrounging1443353scrounging
scrunch1444033scr_unch
scruple1137193scr_uple
scrying1338663scrying_
sponge939663s_po_nge
springe103913983spr_inge
sprung94610033spr_ung_
strange85416343str_ange
strong74914883stro_ng_
stronger9349683stro_nger
strung75213023str_ung_
syringe11349473syr_inge
trounce936823_trounce

Search took 10 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 Filter1786911461620.203880251.2
2DLD Change Limit146162499.28315745.1
3Display Results49490.0301633.3
 (SQL Overall)178691499.51618778.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.