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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
mosher11471979(None) 
cosher114819901cosher
josher164312961josher
kosher134412971kosher
masher114123201masher
moshed124517491moshed
moshers124017841moshers
moshes115222871moshes
mosser84618271mosser
mother113718641mother
musher113820571musher
nosher94616361nosher
posher115018161posher
basher115123812basher
boshes114721882boshes
bosker123813652bosker
bother115218062bother
busher114922202busher
coshed124217552coshed
coshers123618182coshers
coshes115022782coshes
cosier84423762cosier
coster84331292coster
dasher104318982dasher
doser66228562dos_er
dosser74417972dosser
fisher124917142fisher
foster94322222foster
gasher104320372gasher
gopher1239182gopher
gusher104115772gusher
hoser811529762hos_er
hosier94219612hosier
joshed174610902joshed
joshers174111592joshers
joshes165114852joshes
kasher134915032kasher
koshers144811802koshers
lasher94824532lasher
loser54728672los_er
lusher93818762lusher
maser75029972mas_er
mashed125325042mashed
mashers124621052mashers
mashes115030002mashes
masker124416102masker
master84831342master
meshed124415932meshed
meshes115019442meshes
meshier123410852meshier
miser75430402mis_er
mishear1238392mishear
mister84728562mister
mither114218562mither
moaner84415112moaner
mobber123613462mobber
mobster11299212mobster
mocker143315442mocker
mohel104914832mo_hel
mohur1036512mo_hur
moiler84017262moiler
moister94015372moister
molder93819272molder
molter84119422molter
momser104011412momser
momzer19327552momzer
monger94418332monger
monster93214602monster
moocher143610672moocher
mooner85317832mooner
mooter83921092mooter
moper94925922mo_per
mopier103914782mopier
mopper126215002mopper
mosey105922872mos_ey
mosh95227602mosh__
moshav1446052moshav
mossed94818892mossed
mossers94116192mossers
mosses85527682mosses
mossier94413812mossier
moste75925082moste_
mothers123717622mothers
mothery153710512mothery
mothier121910212mothier
mouser85822442mouser
mousier93712462mousier
mouther123812812mouther
mover104220862mo_ver
mower104523452mo_wer
muser76024122mus_er
mushed124420842mushed
mushers124016442mushers
mushes114124562mushes
mushier123813592mushier
muster84724522muster
noshed104413512noshed
noshers103614332noshers
noshes96618232noshes
nosier63716332nosier
nother93815962nother
ocher104516102_ocher
osier53518012_osier
other84219102_other
pisher114317752pisher
poser75128772pos_er
poster84129172poster
pother113818852pother
pusher114318282pusher
rasher95024122rasher
rosier64221272rosier
roster64329082roster
rusher94019652rusher
smasher123911022smasher
smother123510212smother
tocher114014912tocher
toshes94520102toshes
tosser64215662tosser
tother94117142tother
usher84517762_usher
washer124720392washer
wisher123617062wisher
zoster153715852zoster

Search took 9 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 Filter178691825510.763234195.3
2DLD Change Limit825511236.39012918.8
3Display Results1231230.266462.4
 (SQL Overall)1786911237.41924085.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.