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

172 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
moshav144605(None) 
mishap1338872mishap
mocha1249922mocha_
mochas13310662mochas
mosh95227602mosh__
moshavim1882112moshavim
moshed124517492moshed
mosher114719792mosher
moshes115222872moshes
bashaw14349303bashaw
bosh96328973bosh__
boshes114721883boshes
cashaw14439793cashaw
cosh96127623cosh__
coshed124217553coshed
cosher114819903cosher
coshes115022783coshes
costa75523733costa_
costae85319683costae
costal85419513costal
costar85518613costar
cushat113513693cushat
cushaw14386983cushaw
dossal75510303dossal
fossa85812633fossa_
fossae95510373fossae
fossas94610703fossas
gosh86123423gosh__
goshawk1862423goshawk
gossan747233gossan
hosta85917833hosta_
hostas94515833hostas
josh145117613josh__
joshed174610903joshed
josher164312963josher
joshes165114853joshes
kasha124710733kasha_
kashas133311913kashas
kosher134412973kosher
lochan1139093lochan
marshal1238973marshal
masa65034723mas_a_
masas75630413mas_as
mash96039403mash__
mashed125325043mashed
masher114123203masher
mashes115030003mashes
mashie11315933mashie
mashy136016503mash_y
massa75518923massa_
massas85116463massas
mayhap1635233mayhap
mesa67025483mes_a_
mesas76823203mes_as
mescal104113493mescal
mesh96823003mesh__
meshed124415933meshed
meshes115019443meshes
meshy135612783mesh_y
mesial84818083mesial
mesian84315503mesian
messan83912063messan
miseat82925713miseat
misgave13298283misgave
mishaps1438723mishaps
mishear1238393mishear
mishit112618203mishit
miskal123710263miskal
mislay113510683mislay
missal84314903missal
missay114112143missay
moa57249183mo__a_
moan65832023mo__an
moas65545343mo__as
moat66352033mo__at
mobcap1444113mobcap
modal85919243mo_dal
moghul1244473moghul
mohair1135203mo_hair
mohawk1842073mo_hawk
mohel104914833mo_hel
mohur1036513mo_hur
moira71012023moira_
moirai886913moirai
mola66035633mo_la_
molal75120343mo_lal
molar75223093mo_lar
molas75132093mo_las
mollah11319453mollah
momma85111053momma_
mommas94110653mommas
monad85519473mo_nad
monas74732153mo_nas
moola75117033moola_
moolah11409193moolah
moolas83615593moolas
mora66641273mo_ra_
morae75831193mo_rae
moral75533433mo_ral
moras76438783mo_ras
moray105423793mo_ray
morgan9311373morgan
mortal84616853mortal
mortar83812043mortar
mos57067123mos___
mosaic10311143mosaic
moschate1546593moschate
mosey105922873mos_ey
moseys114711713moseys
moshers124017843moshers
moshing134214883moshing
mosk105622443mos__k
mosks116117003mos_ks
mosque17287163mosque
moss67641033mos__s
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
mosso74715183mos_so
mossy105217063mos_sy
most66554203mos__t
moste75925083mos_te
mostly113110943mostly
mosts76028543mos_ts
moth96731333moth__
mother113718643mother
moths106021553moth_s
mothy136214553moth_y
moxa136917743mo_xa_
moxas145014403mo_xas
mughal1236273mughal
musca9311763musca_
muscae10410673muscae
muscat10314663muscat
mush94929123mush__
mushed124420843mushed
musher113820573musher
mushes114124563mushes
mushy135316633mush_y
nosh76223543nosh__
noshed104413513noshed
nosher94616363nosher
noshes96618233noshes
ogham1138253_ogham
osar46820953_os_ar
ossa43714163_ossa_
pasha105417183pasha_
pashas115117063pashas
poisha1135723poisha_
posh95427323posh__
posher115018163posher
poshly1437723poshly
postal84317533postal
pshaw13447513_pshaw
reshave1338603reshave
roshi8310753rosh_i
roshis9311793roshis
sashay1238363sashay
schav1338313_schav
sha69837783__sha_
shad86230913__shad
shag86430563__shag
shah105627783__shah
sham96436363__sham
shat76456603__shat
shave114425893__shave
shaw108132553__shaw
shay107133343__shay
shiv105721173__shiv
tosh74826813tosh__
toshes94520103toshes
wisha114910853wisha_

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 Limit1127161724.90322989.2
3Display Results1721720.0503440.0
 (SQL Overall)1786911725.32933531.8
 
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.