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

97 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
mohawk184207(None) 
mohawks1942121mohawks
dorhawk1841852dorhawk
goshawk1862422goshawk
hawk145521152__hawk
mohair1135202mohair
bohunk1533743bohunk
chalk144814603_chalk
chark144222713_chark
chaw126224633_chaw_
chaws135022463_chaws
dawk126117283__dawk
dhak125512033_dha_k
dorhawks1941613dorhawks
gawk126716693__gawk
goshawks1962053goshawks
gowk125516473go__wk
hack135134543__hack
haik115526983__haik
hank115134143__hank
hark115237393__hark
haw97153273__haw_
hawks155415703__hawks
haws106439443__haws
howk145221963__howk
macaw12311763macaw_
macaws1337023macaws
mack125733653m__ack
mark105138063m__ark
mask105227363m__ask
maw87050103m__aw_
mawn94424143m__awn
maws96437143m__aws
moa57249183mo_a__
moan65832023mo_a_n
moans74624373mo_ans
moas65545343mo_a_s
moat66352033mo_a_t
moats75827643mo_ats
mocha1249923mocha__
mochas13310663mocha_s
mock126429443mo__ck
modal85919243moda_l
modals93914453modals
mohairs1234953mohairs
mohalim1446033mohalim
mohel104914833moh_el
mohels115011323mohels
mohur1036513moh_ur
mohurs1135933mohurs
mola66035633mola__
molal75120343mola_l
molar75223093mola_r
molars85517323molars
molas75132093mola_s
monad85519473mona_d
monads94515303monads
monas74732153mona_s
monk105928523mo__nk
mora66641273mora__
morae75831193mora_e
moral75533433mora_l
morale85220553morale
morals85324633morals
moras76438773mora_s
morass84614493morass
moray105423793mora_y
morays114613883morays
mosaic10311143mosaic
moshav1446053mosha_v
mosk105622443mo__sk
moujik1962883moujik
mow86650353mo__w_
mown95424443mo__wn
mows96340833mo__ws
moxa136917743moxa__
moxas145014393moxa_s
nohow1137293nohow_
oak76238653_o_a_k
pshaw13447513pshaw_
pshaws14435703pshaws
shack145321753_shack
shank125422193_shank
shark126225023_shark
shaw108132553_shaw_
shawl116217573_shawl
shawm135316153_shawm
shawn116417613_shawn
shaws116226263_shaws
soak87227663so_a_k
squawk22385373squawk
thack144915173_thack
thank125817803_thank
thaw107521313_thaw_
thaws116515463_thaws
tomahawk2051743tomahawk
whack174813023_whack

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit112716974.75023729.7
3Display Results97970.0303233.3
 (SQL Overall)178691975.15634656.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.