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 “gentiant” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
gentian8310101gentian_
gentians937561gentians
entrant7318872_entrant
sentient8313632sentient
agential958153agentia_l
agenting1039383agenti_ng
centiare1067203centiare
defiant11311923de_fiant
dentin73919573denti_n_
dentinal939503dentinal
dentine83320243denti_ne
denting94422183denti_ng
dentins83419223denti_ns
dentist8316743denti_st
deviant11311313de_viant
enchant12313123_enchant
entia5318203_entia__
entrants8311753_entrants
extant132714753_ext_ant
gelant72821673ge__lant
gellant83214053ge_llant
genial74917613gen_ia_l
genital849793genita_l
genitals937243genitals
gentil74115123genti__l
gentile83515293genti_le
gentiles93713523gentiles
gentility1347063gentility
gentlest93410573gentlest
gentling1048453gentling
genuine838373genui_ne
germinant1246183germinant
gestalt8411173gest_alt
getting93316563getti_ng
giant65430593g___iant
henting113719653henti_ng
hesitant1149083hesitant
intrant7318753_intrant
lenient7313843len_ient
mediant103516703me_diant
mendicant1466543mendicant
mention9314373mention_
mentions10312893mentions
negotiant1045253negotiant
penchant1549583penchant
pendant10314853pen_dant
penetrant1148463penetrant
penitent10413503penitent
pennant9312493pen_nant
pentane9415743pent_ane
reentrant947843reentrant
reliant7319243re_liant
renitent8315333renitent
renting84026853renti_ng
reptant92817073rept_ant
retint65633443re_ti_nt
retirant8313593re_tirant
sentients948463sentients
sentiment11410723sentiment
sextant142911963sext_ant
tenant6322473ten__ant
tentiest82115613tentiest
tenting84621153tenti_ng
tertian7511193tertian_
tertians839103tertians
venetian1146073venetian_
venetians1244673venetians
ventifact1752833ventifact
venting114218093venti_ng

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 Limit146162697.45619603.3
3Display Results69690.0302300.0
 (SQL Overall)178691697.90622601.9
 
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.