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

115 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
tolidin83924(None) 
tolidine948191tolidine
tolidins948021tolidins
toluidin943861toluidin
colicin11313742colicin
solidi73813152solidi_
tolidines1046882tolidines
toluidine1043802toluidine
toluidins1043432toluidins
xylidin1844332xylidin
allicin949953allicin
amidin94015673_amidin
avidin103510843_avidin
bolide9515563bolid_e
bolides10515073bolides
bolivia1246063bolivia
boudin9412373bo_udin
colicine12312993colicine
colicins12312853colicins
colin76231693col__in
colistin10410553colistin
colitic112916193colitic
colitis92617353colitis
colliding1338583colliding
conidia1069303conidia
conidian1168383conidian
dolphin1345533dolphin
eliding93414343_eliding
eolian6312593eoli_an
folacin1238053folacin
folding123912443fol_ding
folioing1237573folioing
gliadin935593_gliadin
gliding103911843_gliding
golden84411153gol_den
gonidia975903gonidia
gonidic1166103gonidic
hoddin11369943ho_ddin
hoiden103612333ho_iden
holden104113953hol_den
holding123514283hol_ding
holiday1436143holiday
iodin64419353io__din
kallidin1344883kallidin
linin58025523__linin
lipin75518893__lipin
loiding93313403lo_iding
molding114213753mol_ding
oidia6314953_o_idia
olden65114853_ol_den
oldie6415473_ol_die
olefin937583_olefin
olein5316003_ol_ein
olivine1038843_olivine
oolitic92512883oolitic
origin7311033_origin
oxidic1635943_oxidic
paladin101011773paladin
policing13311673policing
politic112918713politic
salicin9311223salicin
sliding93114553_sliding
solanin7311943solanin
soldan73511853sol_dan
soldi65717203sol_di_
solicit9315743solicit
solid65025083solid__
solider82912453solider
solidify1544193solidify
solidity1248113solidity
solidly1137353solidly
solids74116403solid_s
solidus8338113solidus
solion6616383soli_on
soliton7410233soliton
stolid74213183stolid__
stolider936603stolider
stolidity1344683stolidity
stolidly1243833stolidly
tailfin1035693tailfin
talion6317713tali_on
tholepin1344113tholepin
tiding83520093t__iding
tocsin8311003to_csin
toiling83219023to_iling
toiting83217093to_iting
tolan55124013tol__an
told56132203tol_d__
toled65934923toled__
toledo7419993toled_o
toledos8388863toledos
toling73926123toli_ng
tolling83418563tol_ling
tollman935863tollman
tollmen935733tollmen
toluic837693tol_uic
toluid738213tol_uid
toluide835263toluid_e
toluides935553toluides
toluidide1152473toluidide
toluidines1143453toluidines
toluids835323toluid_s
tondi65716143to_ndi_
topspin1145113topspin
torii55521593tori_i_
toxin124716713to__xin
tuladi765723tuladi_
tuladis835703tuladis
tylosin1046903tylosin
tyrocidin15112673tyrocidin
voiding122910363vo_iding
volition1179173volition
volutin1098103volutin
xylidine1943753xylidine
xylidins1943553xylidins

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271156.00022337.8
3Display Results1151150.0502300.0
 (SQL Overall)1786911156.45327691.2
 
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.