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 “repotting” 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
repotting1251112(None) 
replotting1357041replotting
reporting12513901reporting
respotting1347111respotting
besotting12256872besotting
deporting1369592deporting
potting103720892__potting
rebooting12139022rebooting
rebottling1343732rebottling
rebutting1237522rebutting
recoating121317462recoating
recutting1239482recutting
refitting132811122refitting
reknotting1564232reknotting
reletting102713942reletting
remitting122412622remitting
repasting122312842repasting
repeating122618982repeating
repenting122316552repenting
replating122217402replating
repolling122110202repolling
reposing111213802repo_sing
repositing13310492repositing
repouring12310072repouring
reputing112412602rep_uting
rerouting10311872rerouting
resetting102816292resetting
resitting103414872resitting
resorting10614612resorting
retorting10613272retorting
retting83425882re__tting
revetting132912632revetting
revolting1339632revolting
revoting12312032revo_ting
rewetting132710442rewetting
riposting1236062riposting
rotting82919682r__otting
spotting112812092_spotting
allotting1046503allotting
befitting15236623befitting
begetting13186583begetting
beknotting1782813beknotting
besetting12268423besetting
betting103921403be__tting
blotting113910433_blotting
brevetting1644333brevetting
clotting113110643_clotting
coplotting1555953coplotting
crepitating1645803crepitating
decocting1538123decocting
defatting1436103defatting
dehorting1447213dehorting
demitting13239073demitting
demoting12311423demo_ting
denoting10311753deno_ting
departing1349513departing
depicting1537813depicting
depleting1378193depleting
deponing121211213depo_ning
deposing12129773depo_sing
depositing1446933depositing
deputing12238793dep_uting
deratting1139513deratting
devoting1338823devo_ting
dotting93314483__dotting
emitting112410353_emitting
emoting10313563_emo_ting
epoxying2133033_epoxying
exporting1937323exporting
fetting113517873fe__tting
fretting122711523fre__tting
garotting1136103garotting
gavotting1443193gavotting
getting93316563ge__tting
hotting113116523__hotting
importing1438193importing
imposting1436813imposting
inputting1235823inputting
jetting153815343je__tting
jotting152912773__jotting
knotting13236573_knotting
letting83218533le__tting
lotting82917753__lotting
netting84018763ne__tting
patting103722343__patting
petting103720953__petting
pipetting1435513pipetting
pitting103618873__pitting
plotting113011013_plotting
porting103021783__porting
posting105622243__posting
pouting103519943__pouting
precutting1546423precutting
prepasting15168883prepasting
presetting131010833presetting
presorting1339983presorting
putting103218573__putting
ragouting1134893ragouting
ratting83822363r__atting
reacting113317893re_acting
readopting1465513readopting
reallotting1243673reallotting
rebaiting12311643rebaiting
rebating112418343re_bating
rebodying1635003rebodying
reboiling12149823reboiling
rebooking16146393rebooking
reboring11312783rebo_ring
recanting122414823recanting
recasting122414233recasting
reciting113118073re_citing
reclothing1644973reclothing
recoaling121312453recoaling
recocking18138373recocking
recoding122213853reco_ding
recoiling121412413recoiling
recoining121313803recoining
recombing1637323recombing
reconning121410793reconning
recooking16148543recooking
recopying1737113recopying
recording131311623recording
recorking16149643recorking
recounting1339193recounting
recouping1438363recouping
recrating121318793recrating
redacting13612303redacting
redating102620173re_dating
redocking17126783redocking
redoing93516733redo__ing
redonning11127643redonning
reediting11310953reediting
reemitting1346633reemitting
reesting93118273re_esting
reexporting2143423reexporting
refecting152413353refecting
reflating132514713reflating
refloating14198323refloating
refolding1437453refolding
reforging1437663reforging
reforming1538563reforming
refronting1437273refronting
refuting121911903re_futing
regorging1236823regorging
regrating111316213regrating
regretting1237783regretting
reheating132314913reheating
rehousing1337253rehousing
reimporting1644093reimporting
rejecting192211153rejecting
rejoicing19136943rejoicing
rejoining17149223rejoining
reknitting1584993reknitting
relating92725443re_lating
relenting102716773relenting
relisting102414353relisting
reloading1189883reloading
reloaning10710483reloaning
relocating13310873relocating
relocking16137683relocking
relooking14167143relooking
relucting1239773relucting
remating112322423re_mating
remeeting12311433remeeting
remelting12311703remelting
reminting122315103reminting
remolding1338163remolding
remounting1346673remounting
removing1439083remo_ving
renesting102514703renesting
renovating1447423renovating
renowning1336083renowning
renting84026853re__nting
reoiling93217213re_oiling
reopening1248823reopening
repacking1838283repacking
repainting13128973repainting
repairing12310013repairing
reparking1638923reparking
repassing12249423repassing
repatching1844993repatching
repaving142810743rep_aving
repaying142712393rep_aying
repealing122513543repealing
repegging1435593repegging
repelling122312753repelling
repeopling1544233repeopling
reperking1638703reperking
repining114116593rep_ining
repinning12258973repinning
replacing142210163replacing
replanting1338523replanting
replaying15259603replaying
replowing1537413replowing
replying14269403rep_lying
repotted1139283repott_ed
repowering1645273repowering
repping123314983rep__ping
repricing14310473repricing
reprinting131510583reprinting
reprising12312553reprising
reprobating1647103reprobating
reprobing1438073reprobing
reproving1538413reproving
repugning1335863repugning
repulsing1237613repulsing
repumping1634813repumping
requiting1939883requiting
rerenting102617663rerenting
rerolling102210373rerolling
reroofing1336863reroofing
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resettling1135893resettling
reshooting1436223reshooting
resifting133512093resifting
resisting103215313resisting
resiting93521123re_siting
resittings11264553resittings
reslating102516993reslating
resoaking1439373resoaking
resodding1237203resodding
resoling92916303reso_ling
resolving1337743resolving
resonating11311263resonating
resorbing1269353resorbing
resowing123111523reso_wing
respecting1549883respecting
respiting121912863respiting
resplitting1444943resplitting
responding1437403responding
respooling1355743respooling
resprouting1445053resprouting
restating102319413restating
resting85031183re__sting
restoking1438193restoking
restoring10314613restoring
restring91518783re_string
resulting10311083resulting
retasting102513413retasting
retesting102614603retesting
retinting102215253retinting
retitling1039773retitling
retooling1039093retooling
retotaling1186883retotaling
retying113213833re__tying
reuniting10310693reuniting
reverting132315133reverting
revesting132814123revesting
revoicing15117713revoicing
revoking1637803revo_king
revolving1635843revolving
rewording14158543rewording
reworking17136873reworking
rewriting13310413rewriting
rezoning18310453rezo_ning
rioting82716393r_io_ting
rivetting13256413rivetting
roosting93411463r_oosting
rooting83522433r__ooting
rootling9269953r_ootling
rotating92614553r__otating
routing83821093r__outing
rutting82718043r__utting
setting83621393se__tting
shotting123012383_shotting
slotting92612613_slotting
spatting113111763_spatting
spitting113012323_spitting
sporting112415463_sporting
spouting113511953_spouting
stotting92811163_stotting
swotting12268483_swotting
totting82816843__totting
trotting92510913_trotting
vetting114216563ve__tting
wetting114117383we__tting
wotting112913843__wotting

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.420425454.8
2DLD Change Limit1486412796.67322275.0
3Display Results2792790.1401992.9
 (SQL Overall)1786912797.23324705.0
 
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.