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 “refitting” 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
refitting13281112(None) 
befitting15236621befitting
remitting122412621remitting
resitting103414871resitting
defatting1436102defatting
demitting13239072demitting
emitting112410352_emitting
fitting113516562__fitting
rebutting1237522rebutting
reciting113118072reci_ting
recutting1239482recutting
reemitting1346632reemitting
refecting152413352refecting
refighting1845202refighting
refiling123116532refi_ling
refilling13299332refilling
refilming15256462refilming
refinding14259942refinding
refining122416862refi_ning
refiring123513922refi_ring
refixing19329792refi_xing
reflating132514712reflating
refuting121911902ref_uting
reknitting1584992reknitting
reletting102713942reletting
relisting102414352relisting
reminting122315102reminting
repotting12511122repotting
resetting102816292resetting
resifting133512092resifting
resisting103215312resisting
resiting93521122resi_ting
resittings11264552resittings
retinting102215252retinting
retitling1039772retitling
retting83425882re__tting
revetting132912632revetting
rewetting132710442rewetting
unfitting1336422unfitting
admitting1345033admitting
befittingly2051983befittingly
befretting1644793befretting
begetting13186583begetting
belittling1343193belittling
bemisting1438073bemisting
benefitting1752853benefitting
besetting12268423besetting
besotting12256873besotting
betting103921403be__tting
bitting103717293__bitting
brevetting1644333brevetting
crediting1338843credi_ting
crepitating1645803crepitating
debiting122511203debi_ting
defeating142311973defeating
defecting162510223defecting
defiling132812463defi_ling
defining133711803defi_ning
deflating142610713deflating
delisting112710503delisting
depicting1537813depicting
deratting1139513deratting
desisting112810383desisting
deviating14311083deviating
editing9313133_edi_ting
evicting1437483_evicting
eviting11511373_evi_ting
existing1639073_existing
exiting15311393_exi_ting
fatting113818703__fatting
feinting123410833fe_inting
fetting113517873__fetting
fisting113818123__fisting
fittings12318203__fittings
flitting123010883_flitting
formfitting2051893formfitting
fretting122711523fre__tting
fritting123510703_fritting
getting93316563ge__tting
gitting93215703__gitting
gritting10309983_gritting
hefting144510913hef__ting
heisting123411043he_isting
hesitating1448003hesitating
hitting113017273__hitting
jetting153815343je__tting
kitting123214443__kitting
knitting13257023_knitting
leftwing1532973lef_twing
leniting9312353leni_ting
letting83218533le__tting
levitating1446653levitating
mediating13311203mediating
meditating1448123meditating
meriting11314683meri_ting
misfitting1645533misfitting
netting84018763ne__tting
omitting11217743_omitting
outfitting1465823outfitting
permitting1546303permitting
petting103720953pe__tting
pitting103618873__pitting
precutting1546423precutting
predicting1649873predicting
prefiling1549533prefi_ling
prefiring1559073prefi_ring
prefixing2246783prefi_xing
presetting131010833presetting
presifting1638083presifting
profiting1549983profi_ting
quitting18228833_quitting
radiating111112123radiating
rafting113815753raf__ting
ratting83822363r__atting
reacting113317893re_acting
readmitting1544053readmitting
rebaiting12311643rebaiting
rebating112418343re_bating
rebidding14275463rebidding
rebilling12228833rebilling
rebinding13249483rebinding
rebooting12139023rebooting
rebottling1343733rebottling
recanting122414823recanting
recasting122414233recasting
receipting1546753receipting
recoating121317463recoating
recrating121318793recrating
redacting13612303redacting
redating102620173re_dating
redialing11311843redialing
redictating1546803redictating
redipping1555593redipping
reediting11310953reediting
reesting93118273re_esting
refacing142512813ref_acing
refalling132010423refalling
refeeding14247933refeeding
refeeling13229313refeeling
refelling132211313refelling
refencing15188853refencing
referring1338033referring
reffing143712173ref__fing
refiguring1543933refiguring
refiltering1544823refiltering
refitted12309413refitt_ed
reflecting1638823reflecting
reflexing2035933reflexing
refloating14198323refloating
reflowing1636523reflowing
refluxing2034583refluxing
reflying15268173ref_lying
refolding1437453refolding
reforging1437663reforging
reforming1538563reforming
refracting1638733refracting
reframing1538623reframing
refronting1437273refronting
refrying15278903ref_rying
refueling13227973refueling
refuging13218423ref_uging
refunding14258073refunding
refusing122310873ref_using
regilding1236123regilding
regiving13269713regi_ving
regrating111316213regrating
regretting1237783regretting
reheating132314913reheating
rehinging1437453rehinging
rehiring122911883rehi_ring
reifying1539383re_ifying
reigning1039883re_igning
reining84425323re_i_ning
reinking13311023re_inking
reiving113316843re_i_ving
rejecting192211153rejecting
rejigging1933923rejigging
reknotting1564233reknotting
relating92725443re_lating
relenting102716773relenting
relieving1336693relieving
relighting1545853relighting
relining93218743reli_ning
relinking1458253relinking
relishing13229183relishing
reliving122713343reli_ving
relucting1239773relucting
remating112322413re_mating
remeeting12311433remeeting
remelting12311703remelting
reminding132311543reminding
remising112516453remi_sing
remittent1148273remittent
remixing182810333remi_xing
renesting102514703renesting
renigging1235573renigging
renting84026853re__nting
reoiling93217213reoi_ling
reoutfitting1651883reoutfitting
repainting13128973repainting
repasting122312843repasting
repeating122618983repeating
repenting122316553repenting
repining114116593repi_ning
repinning12258973repinning
replating122217403replating
replotting1357043replotting
reporting12513903reporting
reprinting131510583reprinting
reputing112412603re_puting
requiting1939883requiting
rerenting102617663rerenting
rerigging1236553rerigging
rerising93017783reri_sing
rerouting10311873rerouting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resettling1135893resettling
residing103015473resi_ding
resighting1546073resighting
resigning1139463resigning
resiling93520173resi_ling
resinating11313733resinating
resining92919553resi_ning
resituating1247543resituating
resizing182714163resi_zing
reslating102516993reslating
resorting10614613resorting
respiting121912863respiting
resplitting1444943resplitting
respotting1347113respotting
restating102319413restating
resting85031183re__sting
restituting12156563restituting
restring91518783re_string
resulting10311083resulting
retasting102513413retasting
retesting102614603retesting
retieing92913713reti_eing
retiling93319483reti_ling
retiming113014193reti_ming
retiring92717413reti_ring
retorting10613273retorting
retrofitting1653183retrofitting
retwisting1445633retwisting
retying113213833re__tying
reuniting10310693reuniting
reverting132315133reverting
revesting132814123revesting
reviewing1635513reviewing
reviling122917213revi_ling
revising122714403revi_sing
revisiting1446953revisiting
reviving152910503revi_ving
revolting1339633revolting
revoting12312033re_voting
rewinding14238933rewinding
rewinning13257443rewinning
rewiring122911223rewi_ring
rewriting13310413rewriting
rifting113515003r__ifting
rioting82716393r__ioting
rivetting13256413rivetting
rotting82919683r__otting
rutting82718043r__utting
seriating10916403seriating
setting83621393se__tting
shitting123212663_shitting
sitting83519633__sitting
slitting93012583_slitting
spitting113012323_spitting
splitting1236563splitting
twitting12307223_twitting
unremitting1443213unremitting
unwitting1335583unwitting
vetting114216563ve__tting
wetting114117383we__tting
witting113417063__witting

Search took 7 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 Filter1786911486410.440406115.9
2DLD Change Limit1486412796.39023261.5
3Display Results2792790.1401992.9
 (SQL Overall)1786912796.97025637.2
 
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.