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

81 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
dongola94547(None) 
dongolas1045341dongolas
donga76718422dong__a
dongle83612492dong_le
gondola946662gondola
mongol94912532mongol_
mongols103310822mongols
noncola948292noncola
angora71111573_angora
arugola844353arugola
boffola1543463boffola
bongo85720943bongo__
bongoes104314113bongoes
bongos95316653bongo_s
canola8313623can_ola
cingula10327173cingula
coagula1045413coagula
condole102914953condole
conga85419873cong__a
congeal104011683congeal
congo85623133congo__
congoes103617303congoes
congos94219883congo_s
congou94313243congo_u
congous103615083congous
consol82614113consol_
console92715983console
consols92914073consols
dagoba1074943d_agoba
dangle84119303dang_le
dangly114212263dang_ly
dingily1238103dingily
dingle84317073ding_le
dingo74720793dingo__
dingoes94114833dingoes
dobla84913643do__bla
doggo84410703doggo__
doggone1035683doggone
dogma96112463do_g_ma
dona55529633don___a
dong66031653dong___
dongas84914613dong_as
dongles93212873dongles
dongs76525813dong__s
donjon1436463donjo_n
donjons1536733donjons
donna66215033don__na
donor64418193don_o_r
donors75115793don_ors
donzel1636313donzel_
donzels1735393donzels
dooly94821803do__oly
doula65717773do__ula
drongo836793drongo__
drongos935493drongo_s
foveola13115013foveola
gondolas1046193gondolas
googol835843googol_
googols935483googols
lingula8428803lingula
longly10279603long_ly
mandola1039023mandola
mangold1137213mangold
mongo810122413mongo__
mongoe94214983mongo_e
mongoes103415713mongoes
mongolian1244483mongolian
mongos94318623mongo_s
moola75117033mo__ola
moviola1244823moviola
noncolas1048613noncolas
nonpolar1046283nonpolar
nonsolar847083nonsolar
pergola1067623pergola
plugola1043013plugola
roseola777053roseola
rugola736293_rugola
tombola1146103tombola
tonga65619693tong__a
ungula737603_ungula
zonula1537223zon_ula

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.423422437.4
2DLD Change Limit134027816.75019855.9
3Display Results81810.0302700.0
 (SQL Overall)178691817.20324807.9
 
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.