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

163 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
poems9571555(None) 
poem86225771poem_
poets76024441poets
pomes94833931pomes
poms87037741po_ms
proems104711161proems
booms95427122booms
coeds85920162coeds
comes97246992comes
corms95626222corms
deems85421772deems
doers65225712doers
does56554472doe_s
domes85735562domes
doms76239572do_ms
dooms85321342dooms
dorms85723832dorms
doums85417642doums
ems56435492__ems
fems96428702_fems
foams105017952foams
foes76543442foe_s
forms105327052forms
gems75329112_gems
goers65520252goers
goes55644092goe_s
golems939322golems
gorms85619592gorms
haems105517012haems
hems95534942_hems
hoers85724922hoers
hoes75755732hoe_s
holms105117802holms
homes106938812homes
items7499612items
joes116635892joe_s
joeys15518042joeys
koels94613902koels
loams75619862loams
loess55714702loess
looms75124642looms
mems85931502_mems
modems114610762modems
momes95134472momes
moms86539482mo_ms
neems77316292neems
noels56418702noels
noes45845392noe_s
nomes74933122nomes
noms65636402no_ms
norms76019302norms
oes35866192_oe_s
ohms95514032_ohms
oms56337512_o_ms
opens76118552opens
opes65942612ope_s
palms94921752palms
pams85641762p_ams
peas65755062p_eas
pecs84634102p_ecs
peds75835242p_eds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372p_ees
pegs75531762p_egs
pehs95625762p_ehs
pens65649642p_ens
peons75327182peons
peps85134512p_eps
perms95524512perms
pes57259782p_e_s
pets66248332p_ets
pews95731532p_ews
phloems1433522phloems
piers75926332piers
pies66949602pie_s
pleas75627032pleas
plebs95814582plebs
plews105415352plews
plums94619952plums
pocks135022962pocks
pods76540152po_ds
poesy105014062poesy
poet65552902poe_t
pogeys124110352pogeys
pois66539042po_is
pokers124617922pokers
pokes116133012pokes
pokeys15529512pokeys
poleis86018352poleis
polers84225642polers
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pom78249912po_m_
pome85636692po_me
pommy14449862pommy
pomo85828452po_mo
pomos95321582pomos
pomp106225462po_mp
pomps115316192pomps
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112po_os
popes95933812popes
pops86340952po_ps
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
posers84223972posers
poses74642762poses
posts75228782posts
pots66452362po_ts
poufs105616062poufs
pours74623182pours
pouts75530322pouts
powers113822322powers
pows95537662po_ws
poxes145325722poxes
prams96125512prams
prees75937172prees
preps96220692preps
press75425952press
preys105717782preys
prims95425932prims
proem94818272proem_
proms95426402proms
pyes95528992pye_s
rems66237722_rems
roams74919612roams
roes45954132roe_s
roms67038962ro_ms
rooms75324682rooms
seems75525022seems
soms66239372so_ms
stems75219952stems
teems76019782teems
toeas55726422toeas
toes46956442toe_s
tomes76037382tomes
toms68343492to_ms
totems86810762totems
voes75432822voe_s
woes76440662woe_s
worms105320752worms
ylems1039262ylems
zoeas145815612zoeas
zooms164415522zooms

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.0961861364.6
2DLD Change Limit538001631.68631909.8
3Display Results1631630.0305433.3
 (SQL Overall)1786911631.81298615.3
 
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.