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

141 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
presumer124758(None) 
presume11310301presume_
presumed1337961presumed
presumers1336371presumers
presumes1239841presumes
resumer9410111_resumer
perfumer1574552perfumer
preluder1135732preluder
prenumber1543162prenumber
presager1138442presager
presider11410422presider
presser93717622pres_ser
pressmen1238822pressmen
prester93519622pres_ter
resume8313782_resume_
resumed10310622_resumed
resumers1038082_resumers
resumes9313372_resumes
assumer965363_assumer
consumer1238503consumer
creamer113714083cre_amer
dreamer104110843dre_amer
dresser83611953dres_ser
dressier956863dressier
frescoer1345983frescoer
fresher132612643fres_her
freshmen1656023freshmen
grewsomer1542493grewsomer
gruesomer1243003gruesomer
kreuzer2032353kre_uzer
perfume1446503perfume_
perfumed1654533perfumed
perfumers1683713perfumers
perfumery1972373perfumery
perfumes1555893perfumes
perjurer17285903perjurer
persuader1244263persuader
peruser93511373p_eruser
peskier13319113p_eskier
pester84827593p_es_ter
pestier94317403p_estier
preacher153211373preacher
prealter1048863prealter
prearmed1397983prearmed
preaver121011613pre_aver
preciser123411663preciser
precure11312553precure_
precured1339993precured
precures12312903precures
preener93114833pre_ener
prefacer1537983prefacer
prefer113813203pre__fer
pregame1239553pregame_
pregames1339003pregames
prehuman1545033prehuman
prejudger2042553prejudger
prelude1038013prelude_
preluded1236453preluded
preluders1234423preluders
preludes1137833preludes
premed114617753pre__med
premen105017803pre__men
premier113515633pre_mier
premune1138933premune_
prename11412643prename_
prenames12311633prenames
prenomen1249633prenomen
prenumbers1642713prenumbers
preorder1136463preorder
preparer12169643preparer
preppier1156643preppier
prepubes1436053prepubes
prepuce1337833prepuce_
prepuces1438583prepuces
prequel1836343prequ_el
presage10312293presage_
presaged1238803presaged
presagers1236943presagers
presages11312203presages
presale9416353presale_
presales10315263presales
presbyter1643723presbyter
prescore124812353prescore
prese75228383pres__e_
presenter11311633presenter
preserver14127013preserver
preset84430983pres__et
preside10715613preside_
presided12410553presided
presiders1248213presiders
presides11414913presides
presleep1244483presleep
pressed103317303pres_sed
pressers103215023pres_sers
presses93523153pres_ses
pressman1247153pressman
pressmark1762843pressmark
pressor93512873pres_sor
pressure1039773pressure_
pressured1237323pressured
pressures1149063pressures
presters103419003pres_ters
prestore104217343prestore
presumedly1852523presumedly
presuming1437663presuming
presummit1553133presummit
presurgery1642783presurgery
presurvey1744603presurvey
prettier1069043prettier
prevue1179163prevu_e_
prevued1337143prevu_ed
prevues1239263prevu_es
preyer114413733pre__yer
primer105118683pr__imer
primmer134310163pr_immer
prisoner1048573prisoner
prissier10157873prissier
procurer1235833procurer
producer1355843producer
proser84223463pros__er
prosier93817483pros_ier
prosper114012183pros_per
prouder10310373pr_ouder
pruner83413453pr__uner
pursuer9338893pursu_er
reamer84325213_re_amer
rebuker13407843_rebuker
reducer1059003_reducer
refuser104912783_refuser
refuter104312193_refuter
relume8313273_relume_
relumed1069813_relumed
relumes9612513_relumes
renumber1244243_renumber
rescuer939033_rescuer
resider84615803_resider
rester63832433_res_ter
treasurer944253treasurer
tressier847963tressier
wrester102812413wres_ter
wrestler11306993wrestler

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621418.31317582.3
3Display Results1411410.0602350.0
 (SQL Overall)1786911418.52920951.0
 
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.