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

175 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
pomos9532158(None) 
homos105921781homos
nomos75919741nomos
polos76129911polos
pomes94833931pomes
pomo85828451pomo_
pomps115316191pomps
poms87037741pom_s
poos65949111po_os
promos105116421promos
ammos94815822ammos
bohos105618252bohos
bolos75531372bolos
bombs115818822bombs
booms95427122booms
boos67955032bo_os
boyos105418282boyos
bozos165216862bozos
bromos104213312bromos
camos95927612camos
cocos95624692cocos
cohos105921852cohos
comas95833002comas
combos125316612combos
combs116122962combs
comes97246992comes
comose105016842comose
comous10816502comous
compos124818802compos
comps115526052comps
coos67456492co_os
cosmos10311752cosmos
demos86022992demos
dodos75819392dodos
dojos135111792dojos
domes85735562domes
doms76239572dom_s
dooms85321342dooms
duomos936822duomos
gobos86219382gobos
gogos77516522gogos
gombos114311092gombos
goos57644912go_os
hobos106321352hobos
homes106938812homes
hommos13128502hommos
homo96126472homo_
jomon14610082jomon
kobos115616892kobos
kolos94921212kolos
kotos95717702kotos
limos75320812limos
lobos75921842lobos
locos75822602locos
logos67225332logos
looms75124642looms
loos49051122lo_os
lotos54724632lotos
memos95719112memos
mojos145314462mojos
momes95134472momes
moms86539482mom_s
momus96116112momus
monos75930862monos
moos66051302mo_os
mos57067122__mos
mozos165516332mozos
nolos54423352nolos
nomas74726412nomas
nomes74933122nomes
nomoi76012532nomoi
noms65636402nom_s
oms56337512_om_s
onos46229002_onos
pams85641762pam_s
pepos96620082pepos
pesos77221622pesos
phonos114114792phonos
photos113316642photos
pimas94725102pimas
pimps114616982pimps
pisos76021062pisos
poboy121612222poboy
poboys1397312poboys
pocks135022962pocks
poco86826152poco_
pods76540152po_ds
poems95715552poems
poets76024442poets
pois66539042po_is
pokes116133012pokes
poles75351002poles
polios84019722polios
polis74731162polis
polls74627722polls
polo66236632polo_
pols66044562po_ls
polys105718762polys
pom78249912pom__
pome85636692pom_e
pomelos11218132pomelos
pommy14449862pommy
pomp106225462pom_p
pompom1436492pompom
pompoms1535332pompoms
pompon1238942pompon
pompons1338552pompons
pompous1338062pompous
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
poo57757112po_o_
pood75934322po_od
poods85124752poods
poof95541662po_of
poofs105222792poofs
pooh96027382po_oh
poohs103915712poohs
pool65835952po_ol
pools74427702pools
poon67341262po_on
poons75430972poons
poop86532812po_op
poops94422412poops
poor65630222po_or
popes95933812popes
pops86340952po_ps
pores75849032pores
porks115124142porks
pornos85015252pornos
porns75527342porns
porose84818742porose
porous84419482porous
ports75934592ports
poses74642762poses
posts75228782posts
pothos114214692pothos
pots66452362po_ts
pottos84615872pottos
poufs105616062poufs
pours74623182pours
pouts75530322pouts
pows95537662po_ws
poxes145325722poxes
poyou102611522poyou
poyous112911622poyous
praos74923562praos
primos104514422primos
promo95620002promo_
proms95426412prom_s
pros65742782p_ros
prosos85718552prosos
pumas95121562pumas
pumps115520602pumps
pyros105718292pyros
romeos84013172romeos
romps94617542romps
roms67038962rom_s
rooms75324682rooms
rotos56027882rotos
solos54830792solos
somas76030372somas
soms66239372som_s
sumos75720092sumos
tombs97818732tombs
tomes76037382tomes
toms68343492tom_s
topos75726392topos
toros54336192toros
toyos87519142toyos
wombs125813342wombs
woos76238802wo_os
zooms164415522zooms
zoos135828802zo_os

Search took 2 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.310576422.6
2DLD Change Limit538001751.44037361.1
3Display Results1751750.0463804.3
 (SQL Overall)1786911751.79699493.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.