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

224 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
referees11131041(None) 
referee101615751referee_
refereed12149691refereed
refeeds11368972refe_eds
refeels10379692refe_els
refences13311842refences
references1589352references
referent112813422referent
referents12259642referents
referred1297832referred
referrer11136052referrer
referrers12125372referrers
refers93921082refer__s
refires104820312refir_es
reforges12249332reforges
refreezes2153442refreezes
refries104419732ref_ries
refugees12476402refugees
remerges111110202remerges
reserves111011982reserves
retirees84611652retirees
reverers113113152reverers
reveres103621342rever_es
reveries112518512reveries
reverses112513512reverses
rezeroes1737142rezeroes
beebees1138013be_ebees
befrets1237613bef_rets
breweries1447583breweries
celeries10316313celeries
conferees14610623conferees
decrees102513123de_crees
defences1439633defences
defenses1237913defenses
deferences1677873deferences
deferent122712873deferent
deferents13269393deferents
deferred13106363deferred
deferrer12135593deferrer
deferrers13115153deferrers
defers105116943defer__s
deforces14248403deforces
degrees92810723de_grees
demerges12129503demerges
deserves12109893deserves
deterges101510093deterges
emerges101310883_emerges
emeries91620023_emeries
entrees71813773_entrees
feres86038183__fer_es
freebees1345353fre_ebees
frees86131393__f_rees
greegrees1142853greegrees
hexereis1894803hexereis
jeerers14328923je_erers
kedgerees1542693kedgerees
leverets11297603leverets
offerers1434933offerers
peeress939503pe_eress
peeries93623023pe_eries
peewees1236803pe_ewees
preferences1876183preferences
preferred1555003preferred
preferrer1443893preferrer
preferrers1542983preferrers
prefers123713333prefer__s
prefires134313283prefir_es
prefreezes2441993prefreezes
preserves14109073preserves
rearers74323563re_arers
rebores95319163rebor_es
rebreed104611073re_breed
rebreeds11426003rebreeds
reburies10311143reburies
recedes102816063rece_des
receives1339743receives
recesses10312323recesses
recurves1337403recurves
redeems1037163rede_ems
redefies12710163redefies
redenies9615713redenies
redeyes112910973rede_yes
redress82511873re_dress
redries83721713re_dries
reefers103312593re_efers
reekers113613143re_ekers
reelers73520273re_elers
reemerges1255173reemerges
reerect92915883re_erect
reerects10319923re_erects
reeves94721493re_e_ves
refaces123216743ref_aces
refected142311663refected
refects124012743refe_cts
refeed104717623ref__eed
refeel93913243ref__eel
refelled122810173refelled
refels94618053ref__els
refence12312233refence_
refenced1438993refenced
refer84822143refer___
refereeing1444673refereeing
reference14810093reference
referenced1676863referenced
referenda1343073referenda
referral1144403referral
referrals1243493referrals
refiles104122423ref_iles
refineries1347063refineries
refiners114713313refiners
refines105426343ref_ines
refire95419473refir_e_
refired115116993refir_ed
refixes174813173ref_ixes
reflates113115663reflates
reflets103513153ref_lets
reflexes1865933reflexes
reflies104418533ref_lies
refluxes1855183refluxes
reforest1139963reforest
reforests1245533reforests
reforge11259033reforge_
reforged13268703reforged
reformed14249603reformed
reformer13217953reformer
reformers14246403reformers
reforms1239823refor_ms
reframes1338993reframes
refreeze2063263refreeze
refresh1335453ref_resh
refreshes1595953refreshes
refried113513873ref_ried
refuels10399523ref_uels
refugee115310943refugee_
refuges115413373ref_uges
refusers11499273refusers
refuses104918553ref_uses
refuters11449613refuters
refutes104515733ref_utes
regorges10238413regorges
regreen8309043re_green
regreens9257453regreens
regreet83015953re_greet
regreets9287853regreets
regress82711453re_gress
regrets83212923re_grets
rehearses12286843rehearses
reheels10298253rehe_els
rehires105016113rehir_es
rejectees18235423rejectees
releases8313343releases
releves103914973rele_ves
remedies11310553remedies
remeets93712413reme_ets
remerge10148923remerge_
remerged12149173remerged
remorses10311993remorses
renderers10208093renderers
renegers9248793renegers
reneges82513593rene_ges
renewers11238183renewers
repartees1147253repartees
reperked15177793reperked
reperks13298093reper_ks
repress92712683re_press
rescreen1046703rescreen
rescreens1144863rescreens
reseeds84012333rese_eds
reseeks11348623rese_eks
resees63827483r__esees
reseizes1759853reseizes
reserve101011203reserve_
reserved121010583reserved
reserver11119633reserver
reservers12138103reservers
restress82511773restress
resurges9310123resurges
retenes76324623rete_nes
retiree75019083retiree_
retirers84311533retirers
retires74726213retir_es
retries74129073re_tries
returnees9396113returnees
revelers113414133revelers
revelries1246923revelries
revenges1238983revenges
revenues1138663revenues
reverbed14269223reverbed
reverbs12368863rever_bs
revere94621253rever_e_
revered112819333rever_ed
reverences1579173reverences
reverend12288853reverend
reverends13266033reverends
reverent112615093reverent
reverer103815833rever_er
reverie103615163reverie_
revers94529633rever__s
reverse103913743reverse_
reversed122711613reversed
reverser113010483reverser
reversers12298483reversers
reversos11266713reversos
reverted122714713reverted
reverter114812873reverter
reverters122710433reverters
reverts104715043rever_ts
reweaves1436603reweaves
rewires104717113rewir_es
rezeroed1835993rezeroed
rezeros1647453rezer_os
rifeness1138583rifeness
rifleries1247683rifleries
rooftrees1242403rooftrees
roperies10315763roperies
roseries8317313roseries
ruderies9311333ruderies
seeress7311573se_eress
teepees939263te_epees
unfrees1048643unf_rees
veepees1245813ve_epees
veeries102916893ve_eries
veneries112815033veneries
weewees1336563we_ewees

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622247.18620339.8
3Display Results2242240.0932408.6
 (SQL Overall)1786912247.68523251.9
 
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.