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

129 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
reinsert831321(None) 
preinsert1148561preinsert
reinserts946421reinserts
insert64325252__insert
preinserts1243972preinserts
reassert8313672reassert
reinfect1346482reinfect
reinject1745542reinject
reinserted1146682reinserted
reinspect1344292reinspect
reinsure837912reinsure
reinter73116842reinter_
reinters82614772reinters
reinvent1138902reinvent
reinvest1138202reinvest
rinser64317212r_inser_
rinsers73815742r_insers
censer84516583ce_nser_
censers94313903ce_nsers
denser74115193de_nser_
densest83112473de_nsest
desert72725493de__sert
dessert82916453de_ssert
dissert83720693_dissert
enserf9310763_e_nserf
exsert13414363_e_xsert
inert53234373__in_ert
insect83916583__insect
inserts74013993__inserts
inset54430863__inse_t
invert94120083__invert
preinserted1443773preinserted
rainier71614263rainier_
rainiest81214923rainiest
raiser66620103rai_ser_
raisers73617393rai_sers
reasserts945983reasserts
reassort8410683reassort
reconvert1449473reconvert
reenter73217793reenter_
reenters82915303reenters
refiner105316913refin_er_
refiners114713313refin_ers
refinery14447193refin_ery
refuser104912783refuser_
refusers11499273refusers
reifier103414523reifier_
reifiers11309843reifiers
reimport1246503reimport
reincur945133reincur_
reincurs1045553reincurs
reindeer936293reindeer
reindeers1044873reindeers
reindex1536093reinde_x
reindict1187533reindict
reinduct1176153reinduct
reined74425523rein_e_d
reinfects1444723reinfects
reinform1346193reinform
reinjects1844023reinjects
reinjure1544983reinjure
reinjury1842603reinjury
reinked1239793reinke_d
reinless8139433reinless
reins56234563reins___
reinserting1256903reinserting
reinsertion1145443reinsertion
reinsman1045823reinsman
reinsmen1047073reinsmen
reinspects1443033reinspects
reinspire1144223reinspire
reinstate948893reinstate
reinsured1036983reinsured
reinsurer945603reinsurer
reinsurers1043573reinsurers
reinsures937963reinsures
reinvents1246123reinvents
reinvests1244223reinvests
reissuer854523reissuer_
reissuers954033reissuers
reiver95318293rei_ver_
reivers105117083rei_vers
reminder113110513reminder_
reminders12308653reminders
render74024143re_nder_
renders83821673re_nders
renest64529713re_n_est
renitent8315333renitent
rennet64624853re_nne_t
renter64527413re_nter_
renters74224813re_nters
repiner94816903repin_er_
repiners103913433repin_ers
reposer93715333reposer_
reposers102911603reposers
reseat64131493re__seat
resect84424703re__sect
resent63833623re__sent
reset55051863re__se_t
resort65728623re__sort
revert93529113re__vert
reviser104114663reviser_
revisers113511933revisers
rewinder12317663rewinder_
rewinders13246503rewinders
ringent8315153r_ingent
ringer74526063r_inger_
ringers83922953r_ingers
rinse54820973r_inse__
rinsed75016353r_inse_d
rinses64720383r_inse_s
riser55431053r_i_ser_
risers64624783r_i_sers
ruiner64013643ruin_er_
ruiners74213023ruin_ers
seiner64622483sein_er_
seiners74219273sein_ers
seiser65318343sei_ser_
seisers73816393sei_sers
tenser64919433te_nser_
tensest72713313te_nsest
twinset1039373twinse_t
veiner94514753vein_er_
veiners104112523vein_ers
veinier10269583veinier_
veiniest1139383veiniest
veinlet101310573veinle_t
weiner94214133wein_er_
weiners103913063wein_ers

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.423422437.4
2DLD Change Limit1461621297.03020791.2
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.51623774.7
 
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.