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

171 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
zingare173714(None) 
zingara1745511zingara
zingari1745481zingari
zingaro1745121zingaro
infare9313082_infare
ingate73018242_ingate
tinware1038602tinware
zincate1838532zincate
zingani1744812zingani
zingano1744202zingano
zinger163816702zinger_
zingers173514852zingers
zingier17369492zingier
airfare1047243airfare
angary10311323_angary
binary11312223bin_ary
binate8419773bin_ate
binge85125513bing__e
binger94923453binger_
bingers104519993bingers
centare93113703centare
cigar8911803ci_gar_
cigaret10413003ci_garet
cigars9910723ci_gars
dinar66319893din_ar_
dinars75417563din_ars
dinge75627303ding__e
dinger85323673dinger_
dingers94321383dingers
dingier93513673dingier
dingle84317073ding_le
dungaree1045613dungaree
engage82812103_engage
fanfare1336673fanfare
figure10258833fi_gure
finagle11238313finagle
finale94116763fin_ale
finger104920333finger_
fingered13128333fingered
fingerer12127223fingerer
fingers113418433fingers
finmark16154883finmark
gingal81010153ginga_l
gingall9117333gingall
gingals9109313gingals
ginger84920033ginger_
gingered11127743gingered
gingers94118643gingers
gingery12368913gingery
hangar104114513hangar_
hangared1337573hangared
hangars114313493hangars
hinge95323453hing__e
hinger104723333hinger_
hingers113420213hingers
ignore7269063_ignore
inane52820343_in_ane
inarm7314423_in_arm
incage93513623_incage
incase83615283_incase
infares10313023_infares
ingates82716913_ingates
ingle64120433_ing_le
ingrate8715123_ingrate
inhale9411513_inhale
inhere9313713_inhere
injure133410863_injure
inlace82513043_inlace
inmate82917363_inmate
innage73011573_innage
innate63917313_innate
insane6314883_insane
insnare748243_insnare
insure63416603_insure
intake10510863_intake
inure54119053_in_ure
invade10157853_invade
invar839513_invar_
invars9310003_invars
inward10310333_inward
jingal1498593jinga_l
jingall1566173jingall
jingals1588073jingals
jingle143815223jing_le
jingler154311093jingler
kinara10310373kin_ara
kinase104210653kin_ase
ligase7259913li_gase
ligate72519253li_gate
ligure7279473li_gure
linage7713403lin_age
lindane839033lindane
lineage878983lineage
linear65113343linear_
lineate7815153lineate
linga66820823linga__
lingam95112353linga_m
lingams104510193lingams
lingas75116573linga_s
linger75226003linger_
lingered10129643lingered
lingerer9118303lingerer
lingerie959203lingerie
lingers84223303lingers
lingier84113383lingier
linguae8398413linguae
linkage1295963linkage
minae75627723min_a_e
minaret9520683min_aret
mingier103815293mingier
mingle93518783ming_le
mingler104213843mingler
mintage101110123mintage
misgave13298283misgave
niggard1044943niggard
nongame1038183nongame
nonglare946373nonglare
pinger94324093pinger_
pingers104020743pingers
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pinwale1257843pinwale
qindar16317173qindar_
qindars17267423qindars
qintar15359143qintar_
qintars16268573qintars
ringbark1544053ringbark
ringer74526063ringer_
ringers83922953ringers
sangar73617683sangar_
sangaree949333sangaree
sangars83116253sangars
signage937773signage
signore8329093signore
sincere9310553sincere
singable11159543singable
singe65731133sing__e
singer74227313singer_
singers83824703singers
single74520603sing_le
sinkage1287263sinkage
sinuate7412163sinuate
snare54429983_sn_are
stingaree1044473stingaree
tinge64626623ting__e
tingle74319063ting_le
tingler83613343tingler
tinwares1137913tinwares
tzigane1742943tzi_gane
vinegar1134613vinegar_
vinegared1442963vinegared
vinegars1245063vinegars
vinegary1543893vinegary
vintage11128143vintage
virgate1138733virgate
windage1237933windage
winger104125443winger_
wingers113921483wingers
wingier113413283wingier
zincates1937743zincates
zincite1837233zincite
zine137036153zin___e
zing145728613zing___
zinged174414623zing_ed
zinging183513943zinging
zings154620893zing__s
zingy186516133zing__y
zonae145116443zon_a_e
zonary1838793zon_ary
zonate154114923zon_ate

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.1561145455.1
2DLD Change Limit1340271715.78023188.1
3Display Results1711710.0632714.3
 (SQL Overall)1786911715.99929786.8
 
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.