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 “zingara” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
zingara174551(None) 
zingare1737141zingare
zingari1745481zingari
zingaro1745121zingaro
kinara10310372kin_ara
zingani1744812zingani
zingano1744202zingano
zinger163816702zinger_
zingers173514852zingers
angaria8311583_angaria
angary10311323_angary
angora71111573_angora
binary11312223bin_ary
binger94923453binger_
bingers104519993bingers
cigar8911803ci_gar_
cigars9910723ci_gars
cingula10327173cingula
cithara12166513cithara
dinar66319893din_ar_
dinars75417563din_ars
dinger85323673dinger_
dingers94321383dingers
finger104920333finger_
fingers113418433fingers
finmark16154883finmark
gingal81010153ginga_l
gingall9117333gingall
gingals9109313gingals
ginger84920033ginger_
gingers94118643gingers
gingery12368913gingery
gingiva1253293gingiva
hangar104114513hangar_
hangars114313493hangars
hinger104723333hinger_
hingers113420213hingers
inarm7314423_in_arm
indaba935633_indaba
infare9313083_infare
infra838643_in_fra
ingate73018243_ingate
invar839513_invar_
invars9310003_invars
inward10310333_inward
jingal1498593jinga_l
jingall1566173jingall
jingals1588073jingals
kinaras1159123kin_aras
kithara14145193kithara
linear65113343linear_
linga66820823ling__a
lingam95112353linga_m
lingams104510193lingams
lingas75116573linga_s
linger75226003linger_
lingers84223303lingers
lingua7509913ling_ua
lingula8428803lingula
megara9310093_megara
niggard1044943niggard
picara10311903pi_cara
pignora10306363pignora
pinata83817223pin_ata
pinger94324093pinger_
pingers104020743pingers
pintada1096083pintada
qindar16317173qindar_
qindarka2241923qindarka
qindars17267423qindars
qintar15359143qintar_
qintars16268573qintars
ringbark1544053ringbark
ringer74526063ringer_
ringers83922953ringers
sangar73617683sangar_
sangars83116253sangars
signora8348503signora
singer74227313singer_
singers83824703singers
tantara72410823tantara
tiara5315913ti__ara
tinware1038603tinware
vinegar1134613vinegar_
vinegars1245063vinegars
vinegary1543893vinegary
winger104125443winger_
wingers113921483wingers
zanana153810363zan_ana
zenana15297983zen_ana
ziggurat1952393ziggurat
zincate1838533zincate
zing145728613zing___
zinged174414623zing_ed
zingier17369493zingier
zinging183513943zinging
zings154620893zing__s
zingy186516133zing__y
zinnia1536013zin_nia
zonary1838793zon_ary

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.250714764.0
2DLD Change Limit1340271007.01619103.1
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.29624491.6
 
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.