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

150 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
infante10191088(None) 
infant92315131infant_
infanta10237251infanta
infantes11249631infantes
infants102210771infants
andante8311272andante
inane52820342in_an_e
incant82418512incant_
incanted11259542incanted
incants92012802incants
infancy1546172infancy
infantas11246002infantas
infantile1245412infantile
infantine1247142infantine
infantry1443852infantry
infare9313082infa_re
infaunae1143772infaunae
infinite1149592infinite
inflate10312312inflate
ingate73018242inga_te
inmate82917362inma_te
innate63917312inna_te
insane6314892insan_e
ananke1038283an_anke
andantes9310853andantes
ansate64517863ansa_te
ante46538903___ante
binate8419773bin_a_te
cineaste1045743cineaste
diamante1186423diamante
enate54428153en_a_te
enface112510353enfa_ce
enhance1239693enhance
entente7412953entente
fane75343573__fan_e
fate75444283__fa_te
finance1238573fin_ance
ideate7313683idea_te
immane1038883imman_e
impaste11258003impaste
inaner62213543in_aner
inanes62519803in_anes
inanity1039503in_anity
inapt73522693in_apt_
incage93513623inca_ge
incarnate1157223incarnate
incase83615283inca_se
incense92410303incense
incent83320723incent_
incented112412543incented
incenter102212093incenter
incents92414533incents
incite83618733in_cite
indagate1047193indagate
indene73215373inden_e
indent73021243indent_
indented101811733indented
indenter92311443indenter
indents83114663indents
indite73520323in_dite
inearth1037043inearth
infall939403infa_ll
infalls1038943infalls
infamies1346683infamies
infamy1435653infa_my
infancies1446973infancies
infantries1344693infantries
infarct1249013infarct
infarcted1544243infarcted
infarcts1345233infarcts
infares10313023infares
infatuate1244773infatuate
infauna1044403infauna
infaunal1143823infaunal
infaunas1143873infaunas
infect113413443infect_
infected14229403infected
infecter13229153infecter
infects12279713infects
infest93315433infest_
infested12249643infested
infester11239433infester
infests10279793infests
infinites1258693infinites
infinity1447313infinity
inflame1256963inflame
inflated12410863inflated
inflater1149893inflater
inflates11512193inflates
infract12610003infract_
infracted1546363infracted
infracts1346623infracts
infringe1245083infringe
infuse93110573inf_use
ingates82716913inga_tes
ingenue847133ingenue
ingrate8715123ingrate
inhale9411513inha_le
inlace82513043inla_ce
inland7310313inlan_d
inlander937223inlander
inlands838783inlands
inmates92715783inma_tes
innage73011573inna_ge
inosite7314063inosite
insaner7310443insaner
insanity1147333insanity
insnare748243insnare
instance1049883instance
instant7815353instant_
instanter946243instanter
instants8910153instants
instate71616483instate
intact8314663intact_
intake10510863inta_ke
intense72511903intense
intent63122773intent_
intents72115703intents
intine61021983intin_e
intonate8310923intonate
intone61115433inton_e
intranet8418443intranet
intrant7318753intrant_
intrants8312863intrants
invade10157853inva_de
invent93316363invent_
invented122510663invented
inventer112410843inventer
invents102812053invents
invite93715033in_vite
iodate7313503ioda_te
irate55627983i_ra_te
lindane839033lindan_e
lineate7815153linea_te
nance74721843_n_ance
nidate7313783nida_te
nuance859043_nuance
picante11310523picante
pinnate93613743pinna_te
sinfonie1145253sinfonie
sinuate7412163sinua_te
uintaite8127353uintaite
unfaith1345783unfaith
unfancy1545203unfancy
unfasten1144843unfasten
unfence1239193unfence
unwanted12249603unwanted
volante1038513volante
zincate1838533zinca_te
zinfandel2251543zinfandel

Search took 9 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.406440125.6
2DLD Change Limit1340271507.53317792.0
3Display Results1501500.0602500.0
 (SQL Overall)1786911507.99922339.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.