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

91 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
zingaro174512(None) 
zingano1744201zingano
zingara1745511zingara
zingare1737141zingare
zingari1745481zingari
zingani1744812zingani
zinger163816702zinger_
zingers173514852zingers
angary10311323_angary
binary11312223bin_ary
binger94923453binger_
bingers104519993bingers
bingo86020093bing__o
cigar8911803ci_gar_
cigars9910723ci_gars
dinar66319893din_ar_
dinars75417563din_ars
dinero75612643din_ero
dinger85323673dinger_
dingers94321383dingers
dingo74720793ding__o
dinitro845563dinitro
finger104920333finger_
fingers113418433fingers
finmark16154883finmark
gingal81010153ginga_l
gingall9117333gingall
gingals9109313gingals
ginger84920033ginger_
gingers94118643gingers
gingery12368913gingery
gingko12376033ging_ko
hangar104114513hangar_
hangars114313493hangars
hinger104723333hinger_
hingers113420213hingers
inarm7314423_in_arm
infare9313083_infare
ingate73018243_ingate
inro45920793_in__ro
intro54915853_in_tro
invar839513_invar_
invars9310003_invars
inward10310333_inward
jingal1498593jinga_l
jingall1566173jingall
jingals1588073jingals
jingko18505373jing_ko
jingo134615213jing__o
kangaroo1363473kangaroo
kinara10310373kin_ara
linear65113343linear_
linga66820823linga__
lingam95112353linga_m
lingams104510193lingams
lingas75116573linga_s
linger75226003linger_
lingers84223303lingers
lingo66022113ling__o
niggard1044943niggard
picaro10311323pi_caro
pinger94324093pinger_
pingers104020743pingers
pingo87122713ping__o
pintado1096573pintado
pintano998993pintano
qindar16317173qindar_
qindars17267423qindars
qintar15359143qintar_
qintars16268573qintars
ringbark1544053ringbark
ringer74526063ringer_
ringers83922953ringers
sangar73617683sangar_
sangars83116253sangars
singer74227313singer_
singers83824703singers
tinware1038603tinware
vinegar1134613vinegar_
vinegars1245063vinegars
vinegary1543893vinegary
winger104125443winger_
wingers113921483wingers
zincate1838533zincate
zing145728613zing___
zinged174414623zing_ed
zingier17369493zingier
zinging183513943zinging
zings154620893zing__s
zingy186516133zing__y
zonary1838793zon_ary

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.393454684.5
2DLD Change Limit134027916.01622278.4
3Display Results91910.0303033.3
 (SQL Overall)178691916.43927751.4
 
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.