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

237 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
refilter113715(None) 
refilters1236101refilters
defiler113911882defil_er
filter94517632__filter
realter73716312re_alter
reciter94117262reci_ter
refile95122372refil_e_
refiled114318652refil_ed
refiles104122422refil_es
refilled12278672refilled
refilmed14235812refilmed
refiltered1443772refiltered
refiner105316912refi_ner
refitted12309412refitted
refuter104312192ref_uter
register939552register
reinter73116842re_inter
remitter102810322remitter
resilver11337502resilver
resister8311652resister
reviler104314972revil_er
revolter11279362revolter
befinger1434643befinger
befitted14305723befitted
belter84720963be__lter
bewilder1434133bewilder
ceiler84013963ce_il_er
deciliter1247033deciliter
defaulter1343133defaulter
defeater122611663defeater
defier105118653defi__er
defile105216663defil_e_
defiled124013103defil_ed
defilers12439473defil_ers
defiles114016843defil_es
definer114413773defi_ner
deflater123211603deflater
defter104215923def__ter
demister11310223demister
depicter1356853depicter
desalter938363desalter
desilver12286503desilver
emitter93211083_emitter
eviler94811893_evil_er
eviller1056673_eviller
exalter1437563_exalter
exiler134712183_exil_er
falter94519053__falter
filer85433003__fil_er
filler94623623__filler
filmer114112403__filmer
filters103816553__filters
fitter94120033__fitter
hefter124313923hef__ter
heister103613623he_ister
hemipter1545583hemipter
jilter133512513__jilter
keister113011573ke_ister
kelter103214383ke__lter
kilter103714343__kilter
lefter93613433lef__ter
leister73212753le_ister
meister93114163me_ister
melter83520113me__lter
milter84921233__milter
pelter83321623pe__lter
peripter1278753peripter
philter12108213_philter
prealter1048863pre_alter
prefile123413183prefil_e_
prefiled143310573prefil_ed
prefiles133113443prefil_es
prefilled1535513prefilled
profiler13287643profil_er
profiter132710203profi_ter
quilter16279803_quilter
raffler13339223raffl_er
rafter94517583raf__ter
railer64524933r_ail_er
realer63528593re_al_er
realiser82512563realiser
realizer172412113realizer
realters83614043re_alters
realtor73611353re_altor
rebater93517913re_bater
rebilled11318053rebilled
rebutter10106273rebutter
recaller1039323recaller
recanter101913153recanter
recenter102715443recenter
recite83625113reci_te_
recited104319103reci_ted
reciters102613113reci_ters
recites93524583reci_tes
recliner103211913recliner
recoiler103210493recoil_er
redliner93510473redliner
reefier102912553reefi__er
reeler63822573re_el_er
reenter73217793re_enter
refallen1136213refallen
refasten1136103refasten
refected142311663refected
refelled122810163refelled
refelt94521423refelt__
refer84822143ref___er
referrer11136053referrer
refigure1254693refigure
refiling123116533refiling
refill94514053refil__l
refills103711423refil_ls
refilm114311403refil__m
refilms12347503refil_ms
refiltering1544823refiltering
refine95225693refi_ne_
refined114720003refi_ned
refiners114713313refi_ners
refinery14447193refi_nery
refines105426343refi_nes
refire95419473refi_re_
refired115116993refi_red
refires104820313refi_res
refit84230063refi_t__
refits94017653refi_t_s
refixed183611153refi_xed
refixes174813173refi_xes
reflate103516263reflate_
reflated123514293reflated
reflates113115663reflates
reflet94024233ref_l_et
reflets103513153ref_lets
reflew12389453ref_l_ew
reflex16359513ref_l_ex
reflies104418533ref_lies
reflower14126843reflower
refolded1337063refolded
reformer13217953reformer
refunder1236503refunder
refuser104912783ref_user
refute95515703ref_ute_
refuted114313803ref_uted
refuters11449613ref_uters
refutes104515733ref_utes
regaler83814623regal_er
regilded1135543regilded
regilt71217493regilt__
registers1038893registers
reheater113413033reheater
reifier103414523re_ifier
reinters82614773re_inters
reiver95318293re_i_ver
rejecter17258943rejecter
rejigger1743183rejigger
relater73723143re_later
reletter81311023reletter
relier65826183re__lier
reliever11448683reliever
relisted9312623relisted
remaster10311473remaster
remelted11310153remelted
reminder113110513reminder
reminted113615083reminted
remitted113312073remitted
remitters11328403remitters
remittor10316553remittor
remoter94815973re_moter
renter64527413re__nter
reoiled84316853reoil_ed
repeater102615443repeater
repeller103010393repeller
repenter102813863repenter
repiner94816903repi_ner
replier94214973re_plier
reporter10411423reporter
reprinter1197353reprinter
repulser1035803repulser
requiter17168643requiter
reroller8258753reroller
reseller83412223reseller
resetter81511833resetter
resider84615803resi_der
resifted12310153resifted
resigner937793resigner
resile64627673resil_e_
resiled84621983resil_ed
resiles74026543resil_es
resilvers12306503resilvers
resisted9312693resisted
resisters9310453resisters
resistor847673resistor
resite64128453resi_te_
resited85122423resi_ted
resites74027793resi_tes
resolder9259233resolder
resoluter966183resoluter
resolver11339793resolver
resorter8312183resorter
rester63832433re__ster
resulted939713resulted
retailer82911573retail_er
retile65929673retil_e_
retiled84420513retil_ed
retiles74426993retil_es
retinted94414363retinted
retirer74715013reti_rer
retitle73913093retitle_
retitled9339553retitled
retitles83612593retitles
retorter8410733retorter
reuniter838323reuniter
reutter71010093re_utter
reveler104116343revel_er
reveller112912183reveller
reverter114812873reverter
reviewer1434133reviewer
revile94921613revil_e_
reviled114417923revil_ed
revilers114011693revil_ers
reviles104421353revil_es
reviser104114663revi_ser
reviver134411373revi_ver
revolted12319863revolted
revolters12297483revolters
revolver14287713revolver
rewinder12317663rewinder
rewriter1137923rewriter
riffler13328353riffl_er
rifler94014263rif_l_er
rioter64817283r__ioter
ritter63822423r__itter
roilier7311523r_oilier
roister73516203r_oister
ruffler13369723ruffl_er
rufflier1434013rufflier
tilter63417693__tilter
veiler93814353ve_il_er
welter93417383we__lter

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.436409841.7
2DLD Change Limit1461622376.86021306.4
3Display Results2372370.0962468.8
 (SQL Overall)1786912377.39224173.6
 
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.