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

107 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
reinvent113890(None) 
reinvents1246121reinvents
reinvest1138201reinvest
coinvent1348182coinvent
invent93316362__invent
reinfect1346482reinfect
reinject1745542reinject
reinsert8313222reinsert
reinvented1445132reinvented
reinvests1244222reinvests
renitent8315332renitent
ringent8315152r_ingent
coinvents1445663coinvents
convent123919413_convent
desinent9312963desin_ent
eminent9313853emin_ent
event85924443_e__vent
fervent13310063fe_rvent
incent83320723__incent
indent73021243__indent
intent63122773__intent
invents102812053__invents
invert94120083__invert
invest93014843__invest
lenient7313843le_nient
pendent10314723pe_ndent
penitent10413503penitent
preinsert1148573preinsert
prevent124016553pre__vent
raiment9315413rai_ment
rainiest81214923rainiest
reaccent1278573reaccent
reagent8716603re_agent
reanoint8413013reanoint
reascent10411983reascent
reblent9614253re_blent
recement12315653recement
recent83630853re__cent
recipient1348023recipient
reconvene1446493reconvene
reconvert1449473reconvert
redolent9411883redolent
referent112813423referent
refinement1548193refinement
refluent1147433refluent
regent74127673re__gent
regiment114414053regiment
regiven11478323regiven_
regnant8312843regn_ant
reindeer936293reindeer
reindex1536093reinde_x
reindict1187533reindict
reinduct1176153reinduct
reined74425523rein_e_d
reinfects1444723reinfects
reining84425323rein_ing
reinjects1844023reinjects
reinked1239793reinke_d
reinking13311023reinking
reinless8139433reinless
reinserts946423reinserts
reinsmen1047073reinsmen_
reinspect1344303reinspect
reinter73116843reinte_r
reinters82614773reinters
reinvade1244503reinvade
reinventing1545253reinventing
reinvention1454513reinvention
reinvested1444793reinvested
reinvite1177753reinvite
reinvoke1544033reinvoke
reive85522943rei_ve__
reived104518133rei_ve_d
reiver95318293rei_ve_r
reivers105117083rei_vers
reives95723043rei_ve_s
reiving113316843rei_ving
relent64431853re__lent
relevant1149243relevant
relucent1049283relucent
remanent10311703remanent
remitment1349443remitment
remittent1148273remittent
remnant9312643remn_ant
renest64529713re_n_est
rennet64624853re_nne_t
reorient8613473reorient
repent84728873re__pent
repigment1447923repigment
rerent63832453re__rent
resent63833623re__sent
resident9313753resident
resilient9410113resilient
resolvent1246583resolvent
reticent10313293reticent
retinene839803retin_ene
revehent14239083revehent
reverent112615093reverent
revert93529113re__vert
revest94623603re__vest
revet84938843re__ve_t
rewoven13557933rewoven_
rident7520193r_i_dent
riven85121623r_i_ven_
rivet85636363r_i_ve_t
veiniest1139383veiniest
veinlet101310573veinle_t

Search took 10 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.516346300.4
2DLD Change Limit1461621078.46617264.6
3Display Results1071070.0333242.4
 (SQL Overall)1786911079.01519821.5
 
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.