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

134 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
simooms113557(None) 
simoom1037501simoom_
simoons937941simoons
simious939802simious
simoon858062simoo_n
sitcoms1145532sitcoms
bazooms20285383bazooms
bimboes13498733bimboes
bimbos124610523bimbo_s
blooms104613173_blooms
booms95427123__booms
brooms104915873_brooms
diatoms1039073diatoms
dimouts1037893dimouts
dooms85321343__dooms
filmdoms1642503filmdoms
glooms96211683_glooms
grooms94512523_grooms
idioms956413_idioms
imams91511113_im_ams
imaums10106303_imaums
imbosoms1443303_imbosoms
jibbooms21112263jibbooms
jimjams1742073jimjams
kimonos13114633kimonos
limbos104712143limbo_s
limos75320813lim_o_s
looms75124643__looms
mimeos104511543mimeo_s
mimosas1136753mimosas
moms86539483__m_oms
moods85224623__moods
mools76027173__mools
moons75331003__moons
moors74923143__moors
moos66051303__moo_s
moots75831663__moots
nimious937663nimious
nimrods1044283nimrods
pompoms1535333pompoms
rimous8311913rim_ous
rooms75324683__rooms
saloons74415323saloons
saloops93510133saloops
sambos104315193sambo_s
samosas939293samosas
schmoos14347513schmoo_s
schools1249113schools
scoops105414363s_coops
scoots85315943s_coots
scroops11288253scroops
shaloms1288983shaloms
shmoes114612103shm_oes
shmooze21255263shmooze
shmoozes22254883shmoozes
shnooks1485583shnooks
sholoms1278033sholoms
shooks134515633s_hooks
shools94919013s_hools
shoos84226363s_hoo_s
shoots94619363s_hoots
sickos125112033sicko_s
sickrooms1743433sickrooms
siglos7311473siglo_s
sigmoids1244453sigmoids
signors83410913signors
silos56029433si_lo_s
simars84916933sim_ars
simas75727553sim__as
simians959203simians
similes92915233similes
simioid1047993simioid
simlins9311843simlins
simmers113314613simmers
simnels976103simnels
simoleons11132983simoleons
simonies10311113simonies
simonist10410723simonist
simony1137903sim_ony
simpers113014123simpers
simples113014943simples
simps94719763sim__ps
sims65737173si___ms
sinuous739063sinuous
siphons1239353siphons
sitcom1036903sitcom_
sixmos1534813sixmo_s
skidoos1234463skidoo_s
skimos12548803skim_o_s
slaloms9106543slaloms
sloops85513623s_loops
smarms105712533s_marms
smocks145710013s_mocks
smogs85112163s_m_ogs
smokes124814343s_mokes
smolts84411883s_molts
smooch13266803s_mooch
smoosh11236733s_moosh
smooth11259203s_mooth
smooths12216323s_mooths
snoods74312453s_noods
snooks104412833s_nooks
snools65715883s_nools
snoops84314173s_noops
snoots64216683s_noots
sodoms989673s_odoms
soms66239373s___oms
sooks94425453s__ooks
soots55536213s__oots
spoofs114011813s_poofs
spooks124312933s_pooks
spools85115913s_pools
spoons84116023s_poons
spoors84014033s_poors
stooks105115373s_tooks
stools65117023s_tools
stoops85917893s_toops
storms85814633s_torms
summons1158003summons
sumos75720093sum_o_s
sunrooms1045723sunrooms
swoons94511143s_woons
swoops114910923s_woops
symbols1435523symbols
symptoms1743763symptoms
syncoms1435943syncoms
timeous938403timeous
timolols1044333timolols
timorous1047433timorous
unmoors945903unmoors
varooms1248883varooms
vrooms11398713_vrooms
wisdoms1335453wisdoms
zooms164415523__zooms

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271346.42320866.7
3Display Results1341340.0462913.0
 (SQL Overall)1786911346.87525991.4
 
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.