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

334 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
resitting10341487(None) 
refitting132811121refitting
remitting122412621remitting
resetting102816291resetting
resifting133512091resifting
resisting103215311resisting
resiting93521121resi_ting
resittings11264551resittings
befitting15236622befitting
besetting12268422besetting
besotting12256872besotting
demitting13239072demitting
desisting112810382desisting
emitting112410352_emitting
hesitating1448002hesitating
presetting131010832presetting
presifting1638082presifting
rebutting1237522rebutting
reciting113118072reci_ting
recutting1239482recutting
reemitting1346632reemitting
reknitting1584992reknitting
reletting102713942reletting
relisting102414352relisting
reminting122315102reminting
repotting12511122repotting
reseating102421532reseating
resecting122816482resecting
resenting102619292resenting
resettling1135892resettling
residing103015472resi_ding
resighting1546072resighting
resigning1139462resigning
resiling93520172resi_ling
resinating11313732resinating
resining92919552resi_ning
resituating1247542resituating
resizing182714162resi_zing
reslating102516992reslating
resorting10614612resorting
respiting121912862respiting
resplitting1444942resplitting
respotting1347112respotting
restating102319412restating
resting85031182res__ting
restituting12156562restituting
restring91518782res_tring
resulting10311082resulting
retinting102215252retinting
retitling1039772retitling
retting83425882re__tting
revetting132912632revetting
rewetting132710442rewetting
sitting83519632__sitting
admitting1345033admitting
assisting1046183assisting
begetting13186583begetting
belittling1343193belittling
bemisting1438073bemisting
besieging1344763besieging
besmutting1553353besmutting
besting104923923bes__ting
betting103921403be__tting
bitting103717293__bitting
brevetting1644333brevetting
crediting1338843credi_ting
crepitating1645803crepitating
cresting114017043cres__ting
debiting122511203debi_ting
defatting1436103defatting
delisting112710503delisting
depicting1537813depicting
deratting1139513deratting
desalting1138843desalting
deserting11713143deserting
designing1236623designing
desiring10312143desi_ring
despiting13179323despiting
destining11311433destining
destituting13155163destituting
deviating14311083deviating
editing9313133_edi_ting
escoting1158713_escoting
estating92614993_estating
evicting1437483_evicting
eviting11511373_evi_ting
existing1639073_existing
exiting15311393_exi_ting
feinting123410833fe_inting
fetting113517873fe__tting
fitting113516563__fitting
flitting123010883_flitting
fretting122711523fre__tting
fritting123510703_fritting
gestating11229983gestating
getting93316563ge__tting
gitting93215703__gitting
gritting10309983_gritting
heisting123411043he_isting
hitting113017273__hitting
insetting1079283insetting
insisting1038823insisting
jesting154317713jes__ting
jetting153815343je__tting
kitting123214443__kitting
knitting13257023_knitting
leniting9312353leni_ting
lesioning1046443lesioning
letting83218533le__tting
levitating1446653levitating
mediating13311203mediating
meditating1448123meditating
meriting11314683meri_ting
misfitting1645533misfitting
mishitting1645993mishitting
nesting84320443nes__ting
nestling958893nes_tling
netting84018763ne__tting
omitting11217743_omitting
outsitting1147133outsitting
permitting1546303permitting
persisting1346653persisting
pestling111010253pes_tling
petting103720953pe__tting
pitting103618873__pitting
positing11312303posi_ting
precutting1546423precutting
predicting1649873predicting
presenting131013023presenting
presettling1444453presettling
presiding13510903presi_ding
presorting1339983presorting
quitting18228833_quitting
radiating111112123radiating
ratting83822363r__atting
reacting113317893re_acting
readmitting1544053readmitting
rebaiting12311643rebaiting
rebating112418343re_bating
rebidding14275463rebidding
rebilling12228833rebilling
rebinding13249483rebinding
rebooting12139023rebooting
rebottling1343733rebottling
recanting122414823recanting
recasting122414233recasting
receipting1546753receipting
recoating121317463recoating
recrating121318793recrating
redacting13612303redacting
redating102620173re_dating
redialing11311843redialing
redictating1546803redictating
redipping1555593redipping
redshirting1643263redshirting
reediting11310953reediting
reesting93118273re_esting
refecting152413353refecting
refighting1845203refighting
refiling123116533refi_ling
refilling13299333refilling
refilming15256463refilming
refinding14259943refinding
refining122416863refi_ning
refiring123513923refi_ring
refixing19329793refi_xing
reflating132514713reflating
refuting121911903re_futing
regilding1236123regilding
regiving13269713regi_ving
regrating111316213regrating
regretting1237783regretting
reheating132314913reheating
rehinging1437453rehinging
rehiring122911883rehi_ring
reifying1539383re_ifying
reigning1039883re_igning
reining84425323re_i_ning
reinking13311023re_inking
reissuing1034613reissuing
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
repainting13128973repainting
repasting122312843repasting
repeating122618983repeating
repenting122316553repenting
repining114116593repi_ning
repinning12258973repinning
replating122217403replating
replotting1357043replotting
reporting12513903reporting
repositing13310493reposi_ting
reprinting131510583reprinting
reputing112412603re_puting
requiting1939883requiting
rerenting102617663rerenting
rerigging1236553rerigging
rerising93017783reri_sing
rerouting10311873rerouting
resailing103314253resailing
resaluting1137393resaluting
resawing122311433res_awing
resaying122512453res_aying
rescaling122212013rescaling
rescinding1436723rescinding
rescoring12310603rescoring
rescuing1139623res_cuing
resealing102115673resealing
reseeding112410493reseeding
reseeing92412623res_eeing
reseeking14208493reseeking
reseizing19311233reseizing
reselling102213833reselling
resending112313363resending
reserving131110643reserving
resewing122712263res_ewing
reshaping1557743reshaping
reshaving1657273reshaving
reshining13310743reshining
reshipping1843793reshipping
reshoeing1336593reshoeing
reshooting1436223reshooting
reshowing1646633reshowing
resilin72913973resi_lin_
resilins83013373resi_lins
resistant948603resistant
resistive1247583resistive
resmelting1337263resmelting
resoaking1439373resoaking
resodding1237203resodding
resoling92916303res_oling
resolving1337743resolving
resonating11311263resonating
resorbing1269353resorbing
resowing123111523res_owing
respacing1438893respacing
respading1338803respading
respecting1549883respecting
respiring12159903respiring
respring111614063res_pring
restaging112410853restaging
restarting11310663restarting
restitching1744003restitching
restoking1438193restoking
restoring10314613restoring
restricting1449303restricting
restrings10159293res_trings
restrung9176443res_trung
restyling1337923restyling
resubmitting1752033resubmitting
resuming11310083res_uming
resurging1138613resurging
retasting102513413retasting
retesting102614603retesting
retieing92913713reti_eing
retiling93319483reti_ling
retiming113014193reti_ming
retiring92717413reti_ring
retorting10613273retorting
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
rosining92411423rosi_ning
rotting82919683r__otting
russeting1065323russeting
russetting1184253russetting
rusting83821263rus__ting
rustling9249983rus_tling
rutting82718043r__utting
seriating10916403seriating
setting83621393__setting
shitting123212663_shitting
sifting113014593__sifting
silting83320483__silting
siting74126623__si_ting
sittings9339733__sittings
slitting93012583_slitting
spitting113012323_spitting
splitting1236563splitting
testing86021053tes__ting
twitting12307223_twitting
unfitting1336423unfitting
unremitting1443213unremitting
unsetting1088993unsetting
unwitting1335583unwitting
upsetting1275563upsetting
vesicating1646893vesicating
vesting114618683ves__ting
vetting114216563ve__tting
visiting1238393visi_ting
westing115020273wes__ting
wetting114117383we__tting
witting113417063__witting
wresting123811833wres__ting
wrestling1336063wres_tling
zesting174515333zes__ting

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 Filter1786911486410.1531167915.0
2DLD Change Limit1486413347.45619935.8
3Display Results3343340.1532183.0
 (SQL Overall)1786913347.76223021.3
 
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.