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

128 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
preen7592505(None) 
green65522141green
peen65938081p_een
pree67044731pree_
preed85128121preed
preens85020111preens
prees75937171prees
premen105017801premen
treen55622751treen
arene55329412arene
arpen74418042arpen
been65335782_been
boreen8314312boreen
bree67241262bree_
breed85526692breed
brees75632552brees
bren65629562br_en
careen84119492careen
creed85727392creed
creek114917392creek
creel75121482creel
creep95218102creep
dree56638322dree_
dreed75222842dreed
drees65628522drees
free75940182free_
freed95223542freed
freer86021242freer
frees86131392frees
gree56641562gree_
greed75125692greed
greek105915942greek
greens75716872greens
greeny104811452greeny
grees65132472grees
greet65835322greet
keen84830412_keen
kreep114610412kreep
moreen8313342moreen
paean77222722paean
paeon74819492paeon
paten74827342paten
pean66147172p_ean
pee56066512p_ee_
peed76239182p_eed
peek106031432p_eek
peel65535612p_eel
peens76428192p_eens
peep85833692p_eep
peer66238352p_eer
pees65257372p_ees
pein65834942p_ein
pen56558842p__en
peon65635242p_eon
pere66450262pere_
perea75026442perea
pereon83517452pereon
peres76246642peres
pleon74216382pleon
poteen83514262poteen
prawn105312432prawn
prebend12319442prebend
precent113520262precent
preeing103817672preeing
preened103214992preened
preener93114832preener
prefer113813202prefer
preman104117452preman
premed114617762premed
preop94715872preop
prep86427672pr_ep
preps96220692preps
presa74319042presa
prese75228382prese
present94022732present
preset84430982preset
press75425952press
prest75736352prest
preteen939872preteen
pretend104011012pretend
prevent124016552prevent
prex135722972pr_ex
prexes154915952prexes
prexy174611582prexy
prey96228482pr_ey
preyed125313202preyed
preyer114413732preyer
preys105717782preys
prez156126312pr_ez
prezes173614692prezes
pried84426862pried
prier75027762prier
pries74339532pries
prion75119992prion
proem94818272proem
prone75332622prone
proven114314772proven
prune75119632prune
pryer104415312pryer
puree74632842puree_
pureed95017812pureed
purees84721682purees
pyrene113210732pyrene
queen144312062queen
ree37974072_ree_
reed55549622_reed
reef74938212_reef
reek85232522_reek
reel45240532_reel
rees45364192_rees
rein46040892_rein
screen85216022screen
seen46943122_seen
sheen85023312sheen
skeen94817402skeen
spleen8310262spleen
spree74830862spree_
sprees85620642sprees
teen45938202_teen
tree47745812tree_
treed65626732treed
treens65317872treens
trees55835762trees
tureen63312722tureen
tween84413742tween
ween75835462_ween
wheen115016052wheen
wren78221682wr_en

Search took 6 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.796224486.2
2DLD Change Limit538001283.87613880.3
3Display Results1281280.326392.6
 (SQL Overall)1786911284.99835752.5
 
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.