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

130 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
reticent1031329(None) 
reaccent1278572reaccent
reascent10411982reascent
recent83630852re__cent
regiment114414052regiment
relucent1049282relucent
renitent8315332renitent
resident9313752resident
reticence1347622reticence
reticency1644572reticency
reticently1545262reticently
retinene839802retinene
retint65633442reti__nt
retirant8313592retirant
crescent12711053cre_scent
decent94023703de__cent
deficient1547023deficient
dehiscent1545483dehiscent
descent102616293de_scent
desinent9312963desinent
detent73624483det__ent
detriment1249693detriment
eminent9313843_eminent
epicene1148593_epicene
evident1139993_evident
exigent1539513_exigent
lenient7313843leni_ent
medicant13910823medicant
nescient1048713nescient
netizen1635883netizen_
netizens1743863netizens
patient9617073pati_ent
pediment13411393pediment
penitent10413503penitent
percent113520603pe_rcent
pertinent11412273pertinent
pestilent1148843pestilent
precent113520263pre__cent
predicant1449393predicant
prescient13411323prescient
president12410993president
raiment9315413r_aiment
reaccents1365853reaccents
reaccept1465123reaccept
reagent8716603re_agent
reascend1145703reascend
reascents1177403reascents
reblent9614253re_blent
recant83228683re__cant
recement12315653recement
recept103319073re__cept
recipient1348023recipient
redigest1039733redigest
redirect11147993redirect
redolent9411883redolent
referent112813423referent
refluent1147433refluent
regent74127673re__gent
regimen104411573regimen_
regimens11469233regimens
regiments123910323regiments
regiven11478323regiven_
reinvent1138903reinvent
relent64431853re__lent
reliant7319243reli_ant
relicense1145253relicense
relict83623903relic__t
remanent10311703remanent
remint85329973remi__nt
remitment1349443remitment
remittent1148273remittent
renascent1147483renascent
reorient8613473reorient
repent84728873re__pent
repigment1447923repigment
rerent63832453re__rent
rerisen73613643rerisen_
resent63833623re__sent
residents1038423residents
resilient9410103resilient
retaken113911803retaken_
retene69224273ret__ene
retest64028453ret__est
reticences1447453reticences
reticle94112623retic_le
reticles103912483reticles
reticula1047413reticula
reticule1049303reticule
retie55735303reti_e__
retied75924983reti_e_d
retieing92913713retieing
reties65436193reti_e_s
retile65929673retile__
retiled84420513retile_d
retiles74426993retile_s
retiling93319483retiling
retime85321803retime__
retimed104714653retime_d
retimes95020173retime_s
retiming113014193retiming
retina65023383reti__na
retine66237333reti__ne
retinenes9410373retinenes
retines75134673retine_s
retints74717013reti__nts
retirants947323retirants
retire64927013retire__
retired84620143retire_d
retiree75019083retire_e
retirees84611653retirees
retirement1259123retirement
retirer74715013retire_r
retirers84311533retirers
retires74726213retire_s
retiring92717413retiring
retreat7317533ret_reat
revehent14239083revehent
reverent112615093reverent
rewiden1137533rewiden_
rewidens1235533rewidens
rident7520193r__ident
rudiment1147663rudiment
rutilant848063rutilant
sediment11411103sediment
seicento1045043se_icento
sentient8313633senti_ent
sentiment11410713sentiment
urticant1068233urticant
vesicant1347493vesicant
vetivert1446753vetivert

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.1561145455.1
2DLD Change Limit1461621309.18615911.4
3Display Results1301300.0632063.5
 (SQL Overall)1786911309.40518999.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.