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

166 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
problem133598(None) 
problems1434341problems
periblem1445512periblem
probe94320812prob_e_
probed114114822prob_ed
prober104516072prob_er
probes104119452prob_es
proem94818272pro__em
prole74527792pro_le_
proleg94612112pro_leg
proles84627202pro_les
prowled13309912prowled
prowler123310012prowler
roble75223022_roble_
robles85321692_robles
arable81821003arable_
arables91814973arables
broiled103811423broiled
broiler92911753broiler
coble94823173_coble_
cobles104622883_cobles
driblet103712243driblet
drolled93810223drolled
droller84110283droller
drooled9369203drooled
droplet10312113droplet
emblem1237583_emblem
froglet11310063froglet
goblet93219483_goblet
golem8416113_go_lem
growled12278173growled
growler11318973growler
mobled113213183_mobled
noble74420993_noble_
nobler83713453_nobler
nobles83319723_nobles
nonproblem1652393nonproblem
pablum1237503p_ablum
parable111819773parable_
parables121613563parables
parole84425253paro_le_
paroled104217633paro_led
parolee94119643paro_lee
paroles95025883paro_les
pebble1238003pebble_
pebbled1445403pebbled
pebbles1337573pebbles
people10310193people_
peopled1238503peopled
peopler1138083peopler
peoples11312223peoples
periblems1543483periblems
phellem1435833phellem
piolet83225643pio_let
poem86225773p_o__em
pole65951303p_o_le_
poled84934843p_o_led
poler74431793p_o_ler
poles75351003p_o_les
polled94022003p_olled
pollee83623273p_ollee
pollen83416453p_ollen
poller83921853p_oller
pollex153711163p_ollex
poodle93112043poodle_
poodles103013513poodles
pooled94619813p_ooled
pooler83819843p_ooler
prebless1236823prebless
preboom1348253preboom
prelim10311423pr_elim
prilled104713003prilled
probable1439053probable_
probables1545433probables
proband122710243proband
probang12278383probang
probate11414483probate
probated13410863probated
probates12414283probates
probers113514583probers
probing123314443probing
probit103218353prob_it
probits112712573probits
probity14299683probity
proceed12310553proceed
proclaim1446073proclaim
prodded1257733prodded
prodder1147953prodder
proems104711163pro__ems
proffer15126933proffer
profile123211153profile_
profiled14338523profiled
profiler13287643profiler
profiles133211233profiles
progged12409803progged
progger11319373progger
program12311693program
projet15315183pro_jet
prolan8414693pro_lan
prolegs10379993pro_legs
prolix1538683pro_lix
prolog94212973pro_log
prom87631703pro___m
promoed12310083promoed
prone75332623pro_ne_
pronely12310253pronely
pronged113912393pronged
proofed13138723proofed
proofer12149103proofer
propel103714063pro_pel
propels113412843propels
proper104319953pro_per
prophet14316033prophet
propjet1839913propjet
propmen1338763propmen
propped113311953propped
prose75835123pro_se_
prosed94921093pro_sed
proser84223463pro_ser
proses84733473pro_ses
prosier93817483prosier
prosper114012193prosper
prosses94019513prosses
protea82214763pro_tea
protei82615313pro_tei
protium11312293protium
protyle12229453protyle_
protyles13249833protyles
prouder10310383prouder
provable1539093provable_
prove104823193pro_ve_
proved125016033pro_ved
proven114314773pro_ven
prover113819723pro_ver
proves114322253pro_ves
prower114218123pro_wer
prowl105615123prowl__
prowlers13328933prowlers
prowls115511083prowl_s
proxies163014933proxies
riblet84222443_riblet
robbed113415193_robbed
robber103916533_robber
robe65335643_rob_e_
robed85323733_rob_ed
robes75133303_rob_es
roiled74320053_roiled
role45851823_ro_le_
roles56747983_ro_les
rolled74220243_rolled
roller63919793_roller
rouble83913313_rouble_
roubles93413513_roubles
ruble74521253_ruble_
rubles83921703_rubles
subproblem1851573subproblem
treble8311663treble_
trebled1038483trebled
trebles9311443trebles
trolled84312263trolled
troller73913173troller
trolley10328753trolley
trouble957713trouble_
troubled1134983troubled
troubler1035293troubler
troubles1057203troubles

Search took 8 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.393454684.5
2DLD Change Limit1340271667.06018984.0
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.51623774.7
 
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.