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

126 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
mozos16551633(None) 
bozos165216861bozos
mojos145314461mojos
monos75930861monos
moos66051301mo_os
mozo157719741mozo_
bohos105618252bohos
bolos75531372bolos
boos67955032bo_os
boyos105418282boyos
bozo156821412bozo_
cocos95624692cocos
cohos105921852cohos
coos67456492co_os
cozes166033242cozes
dodos75819392dodos
dojos135111792dojos
dozes155226302dozes
gobos86219372gobos
gogos77516522gogos
goos57644912go_os
hobos106321352hobos
homos105921782homos
kobos115616892kobos
kolos94921212kolos
kotos95717692kotos
lobos75921842lobos
locos75822602locos
logos67225332logos
loos49051122lo_os
lotos54724632lotos
makos116518362makos
manos74933612manos
matzos1749262matzos
mayos105521932mayos
mazes165632172mazes
memos95719112memos
mezes167719262mezes
mezzos1635042mezzos
mhos95517772m_hos
milos75428012milos
misos76523292misos
moans74624362moans
moas65545342mo_as
moats75827642moats
mobs85737362mo_bs
mocks135023822mocks
mocs85834902mo_cs
modes85537412modes
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
moils76125742moils
mojo136917222mojo_
mojoes15399522mojoes
mokes114631032mokes
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mo_ls
molts76032092molts
momes95134472momes
moms86539482mo_ms
momus96116112momus
monas74732152monas
mondos95217332mondos
mongos94318622mongos
monks116123392monks
mono66036712mono_
mons68152252mo_ns
moo58460512mo_o_
mood76332062mo_od
moods85224622moods
mool67533862mo_ol
mools76027172mools
moon67140812mo_on
moons75331002moons
moor66628552mo_or
moors74923142moors
moose76327192mo_ose
moot67653622mo_ot
moots75831662moots
mopes95134982mopes
mops85940132mo_ps
moras76438762moras
mores76249642mores
morns75527442morns
moron76925422moron
morons84919542morons
morose85116242morose
morros83714672morros
mors65950062mo_rs
morts75533562morts
mos57067122m__os
mosks116117002mosks
moss67641032mo_ss
mosso74715182mosso
mosts76028542mosts
motes75944002motes
moths106021552moths
motor75317292motor
motors84616592motors
mots66853162mo_ts
mottos84615242mottos
motts76527002motts
moues75732842moues
moves106128422moves
mows96340832mo_ws
moxas145014392moxas
nolos54423352nolos
nomos75919742nomos
onos46229002_onos
oozes145418712oozes
orzos143311252orzos
ouzos143210412ouzos
polos76129912polos
pomos95321582pomos
poos65949112po_os
rotos56027882rotos
solos54830792solos
topos75726392topos
toros54336192toros
toyos87519142toyos
woos76238802wo_os
zoos135828802zo_os

Search took 3 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 Filter178691538000.1731032896.0
2DLD Change Limit538001262.25023911.1
3Display Results1261260.0632000.0
 (SQL Overall)1786911262.48671878.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.