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

261 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
inflate1031231(None) 
inflame1256961inflame
inflated12410861inflated
inflater1149891inflater
inflates11512191inflates
conflate13311172conflate
deflate113613942deflate
enflame1236572enflame
infante101910882infante
infare9313082inf_are
inflamed1446032inflamed
inflamer1356122inflamer
inflames1377312inflames
inflaters1247532inflaters
inflator1158032inflator
ingate73018232in_gate
ingrate8715112ingrate
inlace82513042in_lace
inmate82917352in_mate
innate63917312in_nate
insolate8311892insolate
instate71616472instate
insulate8312842insulate
inulase739412inulase
isolate7313922isolate
reflate103516262reflate
reinflate12157402reinflate
tinplate1047732tinplate
ablate82219213_ablate
acylate12310533acylate
adulate8313223adulate
aflame1138723_aflame
alate55340323__alate
analyte10158813analyte
angulate9312003angulate
animate91617203animate
anlace82513923an_lace
anlage72514223an_lage
annulate8310913annulate
anolyte10158993anolyte
ansate64517863an_sate
binate8419773bin__ate
blate75933783__blate
bullate93415073bullate
canulate10314543canulate
chelate122914893chelate
cholate122114933cholate
cingulate12238583cingulate
collate92919683collate
conflated1539333conflated
conflates14311133conflates
dealate83617843dealate
deflated133412303deflated
deflater123211603deflater
deflates123013943deflates
delate73827753_delate
dilate73220693_dilate
elate55335883__elate
emulate9314123emulate
enate54428143en__ate
enclave1257533enclave
endplate1147083endplate
enface112510353enf_ace
enfilade1243743enfilade
enflamed1455723enflamed
enflames1357023enflames
enframe1247363enframe
enlace82213233en_lace
enolase7310193enolase
enplane939723enplane
enslave1036273enslave
epilate9314283epilate
fate75444283__f_ate
fellate10313433fellate
flake125119973__flake
flame105124443__flame
flare84823633__flare
flat77147823__flat_
flats86429743__flats
flite85424963__flite
flute86823753__flute
flyte115713943__flyte
folate93320393_folate
gallate83417113gallate
gelate73421253_gelate
ideate7313683i_deate
idolater936863idolater
illite63414913i_llite
imamate1138093imamate
imblaze2044313imblaze
imitate9310873imitate
immolate1246543immolate
inane52820343in__ane
incage93513623in_cage
incase83615283in_case
inchoate1347673inchoate
incite83618723in_cite
inclasp1145303inclasp
incline9314643incline
inclose9910223inclose
include1036083include
increate10312203increate
incubate1238663incubate
incudate1138873incudate
inculcate1347433inculcate
inculpate1346793inculpate
indagate1047183indagate
indicate11313353indicate
indite73520313in_dite
indurate9311873indurate
infall939403inf_all
infalls1038943infalls
infamy1435643inf_amy
infant92315133inf_ant
infanta10237253infanta
infantes11249633infantes
infants102210773infants
infares10313023inf_ares
infatuate1244773infatuate
infect113413443infect_
infected14229403infected
infecter13229153infecter
infects12279713infects
infest93315433infest_
infested12249643infested
infester11239433infester
infests10279793infests
infiltrate1354113infiltrate
infinite1149593infinite
inflamers1455213inflamers
inflatable1545993inflatable
inflating13310443inflating
inflation12311093inflation
inflators1257703inflators
inflect1249223inflect
inflected1546053inflected
inflects1336193inflects
inflexed1944013inflexed
inflict1248623inflict
inflicted1545533inflicted
inflicter1444453inflicter
inflicts1345613inflicts
inflow1235293infl_ow
inflows1335523inflows
influx1643723infl_ux
influxes1844343influxes
infra838643infra__
infract12610003infract
infracted1546363infracted
infracts1346623infracts
infrared1236193infrared
infuriate1247643infuriate
infuscate1444333infuscate
infuse93110573inf_use
ingates82716893in_gates
ingle64120433ingl__e
ingrates9514153ingrates
inhale9411513in_hale
initiate8412693initiate
inkle94515833inkl__e
inklike1037033inklike
inlaced10239873in_laced
inlaces92512903in_laces
inlaid7310133in_laid
inland7310313in_land
inlay85214323in_la_y
inlayer1036933in_layer
inlays9389873in_lays
inlet53732403in_let_
inlets63915573in_lets
inmates92715763in_mates
innage73011573in_nage
innovate1145643innovate
inoculate1149623inoculate
inosite7314063inosite
inphase1245383inphase
insane6314883in_sane
inscape1138013inscape
insnare748243insnare
insolated1039713insolated
insolates9311273insolates
instated91613333instated
instates81615823instates
insufflate16122453insufflate
insulated10310713insulated
insulates9311843insulates
inswathe1443693inswathe
intake10510863in_take
intimate101013823intimate
intonate8310923intonate
intubate1047533intubate
inulases838763inulases
inundate946043inundate
invade10157853in_vade
inviolate1246383inviolate
invite93715023in_vite
invocate1347833invocate
involute1145473involute
inweave1344723inweave
iodate7313503i_odate
iolite63221973i_olite
irate55627983i__rate
isolated9410523isolated
isolates8613513isolates
iterate71119103iterate
late47560483___late
ligulate92510243ligulate
lineate7815153lin_eate
lineolate946283lineolate
lingulate10368183lingulate
linoleate944713linoleate
lunulate838243lunulate
malate84624553_malate
negate72915573_negate
nictate9310223nictate
nidate7313783_nidate
niobate937703niobate
nitrate72017013nitrate
notate63217863_notate
nutate63017373_nutate
oblate82214743_oblate
ovulate1039453ovulate
oxalate1457623oxalate
palate84226783_palate
pinnate93613743pin_nate
pinnulate1145753pinnulate
plate74635113__plate
prelate9519693prelate
prolate9419793prolate
reflated123514293reflated
reflates113115653reflates
reinflame14133883reinflame
reinflated14146473reinflated
reinflates13137213reinflates
relate64033633_relate
replate93420053replate
reslate73520593reslate
sibilate1049533sibilate
simulate10311133simulate
sinuate7412153sin_uate
slate55438283__slate
solate64526073_solate
stylate10179773stylate
sublate9315363sublate
sufflate1456183sufflate
sulfate10311653sulfate
tinplates1147763tinplates
ululate749963ululate
uncrate9415953uncrate
undulate9310403undulate
unflawed1536123unflawed
unfluted1237173unfluted
ungulate939803ungulate
uninflated1474763uninflated
unlace82215173un_lace
unlade72714153un_lade
unstate71916213unstate
vallate103016563vallate
velate93720143_velate
violate10311553violate
zincate1838533zin_cate

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272616.86019537.5
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.10925135.9
 
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.