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

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

107 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
refugees1247640(None) 
refugee115310941refugee_
refuges115413371refug_es
referees111310412referees
refuels10399522refu_els
refuge105312612refug_e_
refuged125410872refug_ed
refugeeism165902refugeeism
refusers11499272refusers
refuses104918552refu_ses
refuters11449612refuters
refutes104515722refu_tes
defuels11296983defu_els
defusers12487363defusers
defuses114814593defu_ses
defuzes20398303defu_zes
deluges9169263delug_es
fugles104715783__fugles
fugues104511683__fugues
fusees95416403__fusees
fuzees184910753__fuzees
mergees104411233me_rgees
perigees1189493perigees
ragees74618663r__agees
raggees93710913r_aggees
reargues936713reargues
rebukers14435683rebukers
rebukes134210553rebu_kes
reburies10311143reburies
rebuses94915293rebu_ses
recurves1337403recurves
recuses94619463recu_ses
reducers1147263reducers
reduces10513343redu_ces
refaces123216743ref_aces
refeed104717623ref__eed
refeeds11368973ref_eeds
refeel93913243ref__eel
refeels10379693ref_eels
refels94618053ref__els
refences13311843refences
referee101615753referee_
refereed12149693refereed
refers93921083ref__ers
refights1555883refights
refigures1344543refigures
refiles104122423ref_iles
refiners114713313refiners
refines105426343ref_ines
refires104820313ref_ires
refixes174813173ref_ixes
reflates113115663reflates
reflets103513153ref_lets
reflexes1865923reflexes
reflies104418533ref_lies
refluxes1855183refluxes
reforges12249333reforges
reframes1338993reframes
refreezes2153443refreezes
refries104419733ref_ries
refuel93912623refu__el
refueled1286573refueled
refugeeisms175753refugeeisms
refugia1144313refug_ia
refuging13218423refuging
refugium1443063refugium
refulgences1753353refulgences
refulgent1345403refulgent
refunded1336953refunded
refunder1236503refunder
refunders1334973refunders
refunds11448623refu_nds
refusals1164913refusals
refuse94817513refu_se_
refused115114443refu_sed
refuser104912783refu_ser
refutals1165503refutals
refute95515703refu_te_
refuted114313803refu_ted
refuter104312193refu_ter
regauges1046093regaug_es
reges65628783re__g_es
reggaes948883re_ggaes
rejudges1734153rejudges
rejuggles18122423rejuggles
relumes9612513relu_mes
remiges103015473remig_es
renegers9248793renegers
reneges82513593reneg_es
repugned1235363repugned
repugns1035393repug_ns
repulses1038393repulses
reputes94615963repu_tes
requiems1943253requiems
requires17168703requires
requites171511763requites
resees63827483re__sees
resumers1038083resumers
resumes9313373resu_mes
resurges9310123resurges
retirees84611653retirees
retunes76918403retu_nes
returnees9396113returnees
reuses66025523re_u_ses
revues9813903revu__es
rouges76022383r_oug_es
rupees8312573r__upees

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621077.80018738.7
3Display Results1071070.0303566.7
 (SQL Overall)1786911078.00022336.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.