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

255 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
fontina103863(None) 
fontinas1136851fontinas
cantina93417252cantina
continua1047652continua
cortina91915962cortina
fonding123815422fonding
footing115017592footing
fronting12310442fronting
pontine92419052pontine
sonatina849072sonatina
tontine72316142tontine
wonting113214102wonting
angina7413133_angina
anting75827023_anting
boating103721303boating
bolting104416763bolting
bonding113318433bonding
bonging113316373bonging
boning94223293bon_ing
bonita8312943bon_ita
bonking144116373bonking
booting103821363booting
bunting103718833bunting
cantinas102713773cantinas
canting104725903canting
coating103525303coating
codeina104010323codeina
confine12315583confine
coniine9316803coniine
conin76232723con_in_
conine84528553con_ine
coning94331823con_ing
conins84327233con_ins
conking143618453conking
conning103718753conning
contain9315823contain_
contains10316533contains
contend103511893contend
content94326153content
continual1147143continual
continue10311123continue
continuo1047353continuo
contra83314693cont_ra
coquina1835743coquina
corbina111911443corbina
cortin82423143cortin_
cortinas102212423cortinas
cortins92421313cortins
corvina12229493corvina
costing104323023costing
coting94629253co_ting
cotinga10348023co_tinga
countian1048123countian
counting113115263counting
dentin73919573dentin_
dentinal939503dentinal
dentine83320243dentine
denting94422183denting
dentins83419223dentins
dinting93520553dinting
doating93816863doating
donating10311803donating
donna66215033don__na
donning93512763donning
doting84821913do_ting
dotting93314483dotting
dunting93418383dunting
encina8310443_encina
entia5318203_enti_a
eonian6311833eon_ian
fainting123312163fainting
fanning113615073fanning
fanzine1937123fanzine
farina94618233f_arina
farting114120753farting
fasting114522833fasting
fating105328673f_ating
fatting113818703fatting
feinting123410833feinting
felting113515213felting
fencing132411133fencing
fending123717603fending
feting104417793f_eting
fetting113517873fetting
finding124116543finding
fining104223213fin_ing
finking154016603finking
finning113615113finning
fisting113818123fisting
fitting113516563fitting
flinting123412343flinting
fliting113514613fliting
floating123111883floating
flouting122610473flouting
fluting113815093fluting
flyting14378553flyting
foaling113515843foaling
foaming133612993foaming
fobbing153410273fobbing
foetid10510513foeti_d
fogging133513733fogging
foiling113317653foiling
foin77231563fo__in_
foining113013453foining
foins85523383fo__ins
foisting122910503foisting
folding123912443folding
folia83618933fo_li_a
fomenting1537233fomenting
fondant11311143fondant
fondling13189353fondling
fonduing13245893fonduing
font77143753font___
fontal9313143font_al
fontanel1145553fontanel
fonts86124753font__s
fooling113117373fooling
footie94718133footi_e
footier104115103footier
footies103721543footies
footings12248833footings
footling12239923footling
footman1236403footman
fopping153511133fopping
foramina1346163foramina
forcing134013753forcing
fording123717033fording
forging124114723forging
forint9325023fo_rint
forking154014843forking
formica1436443formica
forming133615733forming
forties104323863forties
fortify1636523fortify
fortis95418613forti_s
fortune1068303fortune
fouling113315373fouling
founding133010783founding
fountain1144923fountain_
fountains1245283fountains
fowling143713113fowling
foxing175012433fo_xing
frontier1147313frontier
frontline1245053frontline
frontman1344303frontman
fronton1037203fronton_
frontons1136503frontons
frosting12311183frosting
funding124113663funding
funkia1336343funki_a
funking154013023funking
funning113813613funning
fustian1036903fustian
gentian8310103gentian
gonging103713033gonging
gonia64117533gon_i_a
hanting114124483hanting
henting113719653henting
hinting113919223hinting
honing103421503hon_ing
honking153414793honking
hooting113919873hooting
hosting114318383hosting
hotting113116513hotting
hunting114317123hunting
intima81910013_intima
intine61021973_intine
jointing16248613jointing
jolting153410913jolting
jotting152912773jotting
konking113510213konking
lantana739603lantana
latina65621143_latina
linting83820983linting
lofting113311313lofting
longing93915783longing
looting83019643looting
lotting82917753lotting
louting83719383louting
lunting83817743lunting
minting103020813minting
moating104218153moating
molting103517173molting
monotint10413713monotint
montane91313623montane
mooting103019363mooting
mounting112711813mounting
muntin82915183muntin_
munting103718773munting
muntins92715133muntins
nandina838913nandina
nomina83113683no_mina
nonfinal1147693nonfinal
nontidal948663nontidal
nontonal849733nontonal
noting74120153no_ting
online6315843_online
ontic74418573_onti_c
optima10106533_optima
opting94514403_opting
ostia52315583_osti_a
outing74128153_outing
panting104025423panting
pastina93914593pastina
patina86022193_patina
platina94413643platina
pointing112813683pointing
poncing122913583poncing
ponding114317083ponding
ponging113416153ponging
pontiff1547903pontiff
pontil8315463ponti_l
pontils9312213pontils
ponton83217643ponton_
pontons93315553pontons
ponying133312123ponying
porting103021783porting
postin83521033postin_
posting105622243posting
postins93721203postins
potting103720893potting
poutine93316823poutine
pouting103519943pouting
punting103318443punting
ranting84025413ranting
renting84026853renting
retina65023383_retina
rooting83522433rooting
rotting82919683rotting
routine72615903routine
routing83821093routing
sestina72711973sestina
sonatinas945683sonatinas
sonatine8313323sonatine
sooting82820953sooting
sorting83221813sorting
tenting84621153tenting
tinting84620603tinting
toiting83217093toiting
tonging93314513tonging
toning74025793ton_ing
tontines82114733tontines
tooting83019423tooting
toting74123793to_ting
totting82816843totting
touting84118453touting
venting114218093venting
voting103916033vo_ting
wanting114220173wanting
wonning113210793wonning
wonton93410963wonton_
wontons103310533wontons
wotting112913843wotting
zoning162914333zon_ing
zonking21359113zonking

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.1531167915.0
2DLD Change Limit1340272557.06318975.9
3Display Results2552550.0962656.3
 (SQL Overall)1786912557.31224438.0
 
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.