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

279 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
referee10161575(None) 
refereed12149691refereed
referees111310411referees
refeed104717622refe_ed
refeel93913242refe_el
refence12312222refence
refer84822142refer__
reference14810082reference
referent112813422referent
referred1297832referred
referrer11136052referrer
refers93921082refer_s
refire95419472refir_e
refired115116992refired
refires104820312refires
reforge11259032reforge
refreeze2063262refreeze
refugee115310942refugee
remerge10148922remerge
reserve101011202reserve
retiree75019082retiree
revere94621252rever_e
revered112819332revered
reverer103815832reverer
reveres103621342reveres
reverie103615162reverie
reverse103913742reverse
beebee10313063be_ebee
before11410153befor_e
befret11315963bef_ret
carefree1346343caref_ree
conferee13613723conferee
decree93117783de_cree
defence1339893defence
defense1137503defense
defer94619753defer__
deference1578483deference
deferent122712873deferent
deferred13106363deferred
deferrer12135593deferrer
defers105116943defer_s
deforce13267243deforce
degree82814853de_gree
demerge11168023demerge
deserve11108703deserve
deterge9118463deterge
eerie55228533_e_erie
emerge91510463_emerge
entree61817883_entree
eterne6311723_eterne
fere76342233__fer_e
feres86038183__feres
fevered14339723fevered
free75940183__f_ree
freebee1238043fre_ebee
greegree1044483greegree
hexerei1764163hexerei
jeered143912793je_ered
jeerer13389933je_erer
kedgeree1444373kedgeree
leered73816223le_ered
levered114212303levered
leveret103014003leveret
metered103514013metered
offered1436143offered
offerer1335543offerer
peered93819483pe_ered
peerie83617893pe_erie
peewee11311963pe_ewee
petered103314963petered
prefer113813203prefer__
preference1776973preference
preferred1555003preferred
preferrer1443893preferrer
prefers123713333prefer_s
prefire124012813prefir_e
prefired144310753prefired
prefires134313283prefires
prefreeze2342093prefreeze
preserve13108793preserve
raftered1237663raftered
reared75930013re_ared
rearer64928913re_arer
rebore86625643rebor_e
rebored105015883rebored
rebores95319163rebores
rebred95816353re_bred
rebreed104611073rebreed
recede95515533rece_de
receded112713043receded
recedes102816063recedes
receive1239733receive
recurve1237403recurve
redeem9311523rede_em
redeye103811793rede_ye
redeyes112910973redeyes
redrew10309503re_drew
reeded84022563re_eded
reefed103816583re_efed
reefer93314363re_efer
reefers103312593reefer_s
reefier102912553reefier
reeked113717643re_eked
reeker103715593re_eker
reeled74725533re_eled
reeler63822573re_eler
reemerge1154793reemerge
reerect92915883re_erect
reeve84121323re_e_ve
reeved104118713re_eved
reeves94721493re_eves
reface113616353ref_ace
refaced133713573refaced
refaces123216743refaces
refect114319333refe_ct
refected142311663refected
refects124012743refects
refed93921923ref__ed
refeeds11368973refeeds
refeels10379693refeels
refel84920813ref__el
refell94214443refe_ll
refelled122810163refelled
refels94618053refe_ls
refelt94521423refe_lt
refenced1438993refenced
refences13311843refences
referable1439623referable
refereeing1444673refereeing
referenced1676863referenced
references1589353references
referenda1343073referenda
referents12259643referents
referral1144403referral
referrers12125373referrers
reffed134712513ref_fed
refile95122373ref_ile
refiled114318653refiled
refiles104122423refiles
refine95225693ref_ine
refined114720003refined
refiner105316913refiner
refines105426343refines
refixed183611153refixed
refixes174813173refixes
reflate103516263reflate
reflet94024233ref_let
reflew12389453ref_lew
reflex16359513ref_lex
reflexed1975233reflexed
reflexes1865923reflexes
reflies104418533reflies
reforest1139963reforest
reforged13268703reforged
reforges12249333reforges
reform11312703refor_m
reformed14249603reformed
reformer13217953reformer
reforms1239813reforms
reframe1239393reframe
refreezes2153443refreezes
refresh1335453refresh
refried113513873refried
refries104419733refries
refroze1956223refroze
refry114412463ref_r_y
refuel93912623ref_uel
refueled1286573refueled
refuge105312613ref_uge
refuged125410873refuged
refugees12476403refugees
refuges115413373refuges
refuse94817513ref_use
refused115114443refused
refuser104912783refuser
refuses104918553refuses
refute95515703ref_ute
refuted114313803refuted
refuter104312193refuter
refutes104515723refutes
regeared1039433regeared
regorge9257833regorge
regreen8309043regreen
regreet83015953regreet
regret73723533re_gret
regrew10388563re_grew
rehearse11296653rehearse
reheel93610823rehe_el
rehire95415863rehir_e
rehired115013153rehired
rehires105016113rehires
rejectee17289623rejectee
rekeyed1536163rekeyed
release7312763release
releve95116403rele_ve
releves103914973releves
remeet86325473reme_et
remerged12149173remerged
remerges111110203remerges
remorse9311713remorse
rendered102512263rendered
renderer9239743renderer
renege72713763rene_ge
reneged92010763reneged
reneger8299493reneger
reneges82513593reneges
renewed11309993renewed
renewer10248693renewer
reoffered1643313reoffered
repartee10312753repartee
reperk122511773reper_k
reperked15177793reperked
reperks13298093reperks
rescreen1046703rescreen
resee54336333r__esee
reseed74823293rese_ed
reseek103813133rese_ek
reseen64318413rese_en
resees63827483rese_es
reseize1639553reseize
reserved121010583reserved
reserver11119633reserver
reserves111011983reserves
resewed113011823resewed
resurge839073resurge
retene69224273rete_ne
retenes76324623retenes
retire64927013retir_e
retired84620143retired
retirees84611653retirees
retirer74715013retirer
retires74726213retires
retore67630763retor_e
returnee8449883returnee
reveled113917753reveled
reveler104116343reveler
revenge1138573revenge
revenue1039533revenue
reverb113912573rever_b
reverbed14269223reverbed
reverbs12368863reverbs
reverence14710153reverence
reverend12288853reverend
reverent112615093reverent
reverers113113153reverers
reveries112518513reveries
revers94529633rever_s
reversed122711613reversed
reverser113010483reverser
reverses112513513reverses
reverso10367693reverso
revert93529113rever_t
reverted122714713reverted
reverter114812873reverter
reverts104715043reverts
revery124014213rever_y
reweave1336773reweave
rewire95421403rewir_e
rewired115413283rewired
rewires104717113rewires
rewore938030153rewor_e
rezero1578873rezer_o
rezeroed1835993rezeroed
rezeroes1737143rezeroes
rezeros1647453rezeros
rifer84721983rifer__
rogered939553rogered
rooftree1163353rooftree
severe94016083sever_e
severed113513863severed
severer103511563severer
sewered112911243sewered
teepee8314363te_epee
telfered1234883telfered
unfree9413203unf_ree
veepee11311483ve_epee
veered103612743ve_ered
wafered14288433wafered
weewee12310083we_ewee

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272796.94019312.2
3Display Results2792790.0933000.0
 (SQL Overall)1786912797.18624866.5
 
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.