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

102 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
gunwale113473(None) 
gunwales1244731gunwales
pinwale1257842pinwale
unbale83616402_unbale
bubale104014623bu_bale
bundle94315573bun_dle
bungle97116113bun_gle
cuneal8611513cuneal_
cuneate9311723cuneate
dunnage9175213dunnage
finale94116763fin_ale
fungal10388733fungal_
fungals11276783fungals
funicle12237483funicle
gadwall1244563gadwall
gale56347323g___ale
genial74917613genial_
gentile83515293gentile
gentle74014513gen_tle
gingal81010153gingal_
gingall9117333gingall
gingals9109313gingals
gnawable1435683gnawable
growable1435623growable
gruntle8257053grun_tle
guanase836213guanase
guayule1142823guayule
guggle94110433gu_ggle
guidable1236203guidable
guile64521133gu__ile
gullable1136463gullable
gumball1266833gumball
gunfire1134743gunfire
gunite7414403gun_ite
gunkhole1693253gunkhole
gunman9299453gunma_n
gunnel73411053gunnel_
gunnels8358563gunnels
gunpaper1342623gunpaper
gunplay1343233gunplay
gunsel7339853gunsel_
gunsels8338133gunsels
gurgle83912473gu_rgle
gustable11138203gustable
guttae73210583gutta_e
guttate8328903guttate
guttle74111973gu_ttle
guzzle15297913gu_zzle
huntable1338093huntable
inhale9411513_inhale
inwall938343_inwall
jungle144012653jun_gle
lunate6316043lun_ate
lunulae735613lunulae
lunule638433lun_ule
mundane1038073mundane
nonwage1137163nonwage
nuncle839363nun_cle
outwalk1437623outwalk
outwile10310263outwile
pinwales1367963pinwales
pungle94413573pun_gle
quale143617853qu__ale
rundle73214233run_dle
runkle103611543run_kle
runway12105973runwa_y
runways13134443runways
subsale9310543subsale
sundae7312873sunda_e
sunward1137653sunward
sunwise1036433sunwise
swale85221593__swale
tinware1038603tinware
tunable92511313tunable
tuneable1038913tuneable
tunicle9308033tunicle
tunnage8166373tunnage
unable83819223_unable
unawake1445343_unawake
unaware1038033_unaware
unbaled103315963_unbaled
unbales92914863_unbales
uncage93014873_uncage
uncake122813523_uncake
uncase83817433_uncase
uncle7317053_un_cle
unease63816643_unease
unlace82215173_unlace
unlade72714153_unlade
unmade92911063_unmade
unmake122811213_unmake
unpile81914323_unpile
unsafe9310693_unsafe
untame82513603_untame
unwalled1288653_unwalled
unwary1239823_unwary
unwaxed18308393_unwaxed
unweave1336363_unweave
unwell9349443_unwell
unwise9510803_unwise
unwove12238883_unwove
wale74546433___wale

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.406440125.6
2DLD Change Limit1340271026.00022337.8
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.43627764.3
 
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.