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

165 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
retinite831485(None) 
retinites9313501retinites
definite1239322definite
melinite10411752melinite
reignite947232reignite
reincite1089702re_incite
reinvite1177752re_invite
resinate8316772resinate
retinae75517332retin_ae
retine66237332retin__e
retinene839802retinene
retinitis948022retinitis
retint65633442retin_t_
retinted94414362retin_ted
retints74717012retin_ts
retinue75414842retin_ue
reunite7312712re_unite
actiniae101810013actiniae
actinide11199213actinide
arenite71017713are__nite
autunite856693autunite
bentonite1146163bentonite
cotinine10311493cotinine
creatinine1245073creatinine
cretinism1347123cretinism
crinite9513633_crinite
cutinise1048763cutinise
cutinize1948533cutinize
detente83313603deten_te
detinue85010033detin_ue
detonate9311193detonate
ebonite9310293_ebonite
felinity1447283felinity
feminie12179933femini_e
feminine13199783feminine
feminise132010293feminise
feminity1647543feminity
feminize22199373feminize
festinate1249473festinate
feticide1447503feticide
fetidity1545853fetidity
finite9316823__finite
gelignite1143993gelignite
geminate11411813geminate
heinie92512663he_ini_e
infinite1149593infinite
kainite1149543_kainite
kernite1159473ke_rnite
latinity1138813latinity
latinize17610563latinize
lenite6719983le__nite
lewisite1154543lewisite
meinie82614523me_ini_e
melanite10512033melanite
melilite10410573melilite
melinites11310413melinites
patinate103016313patinate
patinize19610773patinize
pectinate1349553pectinate
petite84320653pet__ite
pinite8321243__pinite
preinvite1485443pre_invite
preterite11613203preterite
preunite1039573pre_unite
raticide1148943raticide
ratine65131823ratin__e
ratite65022423rat__ite
recite83625113re__cite
reclinate11410023reclinate
recondite1248963recondite
redingote1143463redingote
redivide1355933redivide
refine95225693refin__e
refining122416863refining
refinish1447893refinish
regicide1245923regicide
reginae84713453regin_ae
rehinge1148503rehin_ge
reignited1145683reignited
reignites1046933reignites
reincited1246853re_incited
reincites1148493re_incites
reining84425323re_ining
reinter73116843re_in_ter
reinvited1386193re_invited
reinvites1287033re_invites
rekindle1344643rekindle
reknit10312533re_knit_
reknits1137073re_knits
reline65434353relin__e
relining93218743relining
reminisce1345473reminisce
remint85329983remin_t_
reminted113615083remin_ted
remints95117293remin_ts
rente54733783re__n_te
repine85627813repin__e
repining114116593repining
requisite1865423requisite
requite162012483re_quite
resinated10413283resinated
resinates9314763resinates
resinify1445053resinify
resining92919553resining
resinlike1344363resinlike
resite64128453re__site
resonate8513513resonate
respite9513033re_spite
restitute947753restitute
retaining102114733retaining
retaliate9410643retaliate
retaste72313133ret_aste
retene69224273reten__e
retentive1249853retentive
reticle94112623reti_cle
reticule1049303reticule
retie55735303ret__i_e
retieing92913713retieing
retighten1374773retighten
retile65929673ret__ile
retiling93319483retiling
retime85321803ret__ime
retiming113014193retiming
retina65023383retin__a
retinal75318353retin_al
retinals85612963retinals
retinas74819353retin_as
retinenes9410373retinenes
retines75134673retin_es
retinitides1244743retinitides
retinitises1145983retinitises
retinoid947353retinoid
retinoids1045383retinoids
retinol7469693retin_ol
retinols8419743retinols
retinting102215253retinting
retinued95210823retinued
retinues85113153retinues
retinula845723retinula
retinulae945363retinulae
retire64927013ret__ire
retiree75019083reti_ree
retiring92717413retiring
retitle73913093reti_tle
retune69121953retun__e
retuning9311583retuning
reunited939713re_united
reuniter838323re_uniter
reunites8312473re_unites
reutilize1847653reutilize
revisit10311373revisit_
revisited1346573revisited
revisits1137423revisits
rewrite10311143re_write
rexine134719443rexin__e
routinize1846203routinize
ruinate7312833r_uinate
ruminate10511473ruminate
selenite81713113selenite
sternite8310543sternite
stibnite1044073_stibnite
tetanise8610203tetanise
tetanize17109953tetanize
titanite898433titanite
uraninite946743uraninite

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.420425454.8
2DLD Change Limit1461621656.67321903.5
3Display Results1651650.0762171.1
 (SQL Overall)1786911657.16924925.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.