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

143 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
schmoos1434751(None) 
schmoes14308541schmoes
schmoose15295971schmoose
schmos13379151schm_os
schizos21115432schizos
schmo124510202schm_o_
schmoe13328332schm_oe
schmoosed17294302schmoosed
schmooses16275632schmooses
schmooze24255012schmooze
schmoozes25214902schmoozes
schmoozy27262862schmoozy
schnook1654482schnook
schnooks1754242schnooks
school11410722sch_ool
schools1249112schools
schrods1337432schrods
shmoes114612102s_hmoes
shoos84226362s_h_oos
achoo10315083ach_oo_
cameos105818003_cameos
camos95927613_cam_os
campos125217953_campos
chamois143512193_chamois
chaos105622863_ch_aos
chemos13311723_chemos
chicos134614833_chicos
chinos115018693_chinos
chiros114617773_chiros
cholos114716853_cholos
chomps155112223_chomps
chook146015043_ch_ook
chooks155312793_chooks
choose115116143_ch_oose
choosy14459103_ch_oosy
chops125019873_ch_ops
chows135618203_ch_ows
chromos142610273_chromos
chymous1775703_chymous
combos125316613_combos
comous10816513_comous
compos124818803_compos
coos67456493_c__oos
cymols1377193_cymols
cymous1388403_cymous
echoes114715523ech_oes
echos105216463ech__os
homos105921793__homos
ichors11310423ich_ors
moos66051303___moos
ochrous1237943ochrous
salmons93713263salmons
sambos104315193s_ambos
scamps125014173scam_ps
scams94423973scam__s
schavs1436493sch_avs
schemas1468163schemas
schemers1576713schemers
schemes1489663schemes
scherzos2243703scherzos
schisms1437173schisms
schists1248543schists
schizo20115993schizo_
schleps1445483schleps
schlock18235873schlock
schlocks19245693schlocks
schlubs1443193schlubs
schmalz2345293schmalz
schmear1484043schmear
schmears1584103schmears
schmeer1475363schmeer
schmeers1574833schmeers
schmoosing1843143schmoosing
schmoozed26244133schmoozed
schmoozer25224363schmoozer
schmoozers26223263schmoozers
schmuck2043043schmuck
schmucks2142763schmucks
schnaps1443703schnaps
schnoz2035653sch_noz
schnozes2244493schnozes
schnozz2042733schnozz
schorl1179813sch_orl
schorls1248353schorls
schriks16185743schriks
schrod1247883sch_rod
schtiks16184743schtiks
schuits1235823schuits
schuls11299853sch_uls
schuss11186733sch_uss
schwas14396983sch_was
scions82612243sc_ions
scoop95617163sc__oop
scoops105414363sc_oops
scoot75729153sc__oot
scoots85315943sc_oots
scops95820193sc__ops
scots74025913sc__ots
scows106617803sc__ows
scrods94111613sc_rods
scroop10299783sc_roop
scroops11288253scroops
scums95017423scum__s
sermons9311783sermons
shakos134912193s_hakos
shammos14307203shammos
shamois123210423shamois
shamos114216983s_hamos
shamoys15367283shamoys
shampoos1544603shampoos
sheols94614163s_heols
shmo95318103s_hm_o_
shmooze21255263s_hmooze
shmoozes22254883s_hmoozes
shnook1366343s_hnook
shnooks1485583s_hnooks
shoes85429663s_h_oes
shogs95319713s_h_ogs
shoo75929893s_h_oo_
shook124920163s_h_ook
shooks134515633s_hooks
shool84523153s_h_ool
shools94919013s_hools
shoon84022013s_h_oon
shoot84235913s_h_oot
shoots94619363s_hoots
shops104222903s_h_ops
shots84730853s_h_ots
shows115324583s_h_ows
simoom1037503s_imoom
simooms1135573s_imooms
simoon858063s_imoon
simoons937943s_imoons
sixmos1534813sixm_os
skidoos1234463skidoos
skimos12548803skim_os
smogs85112163s__mogs
smoosh11236733s__moosh
spumous1135853spumous
summons1158003summons
sumos75720093s_um_os
wahoos122310593wah_oos
yahoos12209243yah_oos

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 Limit1340271436.17021722.4
3Display Results1431430.0463108.7
 (SQL Overall)1786911436.62226984.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.