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

148 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
preedits116876(None) 
preedit10512461preedit_
reedits8511741_reedits
credits1039972cr_edits
peewits12105872p_eewits
preadmits1444922preadmits
preaudits1265022preaudits
predicts1339612pr_edicts
preedited1337632preedited
preemies12512192preemies
preempts1444542preempts
preexist1747962preexist
preexists1844732preexists
premedics1645302premedics
preterits11410962preterits
reedit7617222_reedit_
reemits9611302_reemits
beedies10314203_beedies
breeders11368893breeders
breeding123411843breeding
breedings13375763breedings
breeds94914883breed__s
coedits10310243_coedits
credit9315193cr_edit_
creeds94714773creed__s
creepies1239613creepies
edits65819033___edits
freebies1337873freebies
freedoms1445433freedoms
freesias1146333freesias
greedier1036083greedier
greediest1147553greediest
greedily1345183greedily
greeds84314283greed__s
greenies9312673greenies
greets75117423gree__ts
heredity1546493heredity
misedits1147963misedits
overedits1346813overedits
pandits103914213p_andits
peeries93623023p_eeries
peewit111110903p_eewit_
peridots1138323peridots
permits11314003p_ermits
pewits112810683p__ewits
plaudits1144263plaudits
praedial1178763praedial
preacts113211363pr_eacts
preadapts1444003preadapts
preadmit1346813preadmit_
preadopts1445143preadopts
preadults1244283preadults
preaudit1177023preaudit_
prebids12399883pr_ebids
preboils1267293preboils
precasts1239453precasts
precedents1545723precedents
precedes13310713preced_es
preceding15129363preceding
precents123015043precents
precepts14268893precepts
precis103416703pr_eci_s
precuts111710473pr_ecuts
predate10616893pr_edate
predates11615813pr_edates
predeath1447003predeath
predeaths1544743predeaths
prededucts1642223prededucts
predial103815413pr_edial
predict12315323pr_edict
predive13511083pr_edive
predries112714383predries
preed85128123preed___
preediting1447933preediting
preeing103817673pree_ing
preelects1356083preelects
preemie11310563preemi_e
preempt1337723preempt_
preenacts1345843preenacts
preeners102712813preeners
preening113115843preening
preens85020113pree__ns
preerects1345413preerects
prees75937173pree___s
preexcite2044683preexcite
preexcites2144163preexcites
prefects1598133prefects
preheats1339413preheats
prelects1299723prelects
prelimits1366013prelimits
prelims1139823pr_elims
premedic1546303premedi_c
premeds12389593premed__s
premies113823063pr_emies
premiss113513813pr_emiss
preppies1149683preppies
preprints1347473preprints
presents103315643presents
presets94216423pr_esets
preships1539313preships
presides11414913presides
presidios1245773presidios
presifts1366593presifts
presorts105311683presorts
prests84021263pr_e_sts
preterit10315843preterit_
preterite11613203preterite
preterites12411793preterites
pretermits1445033pretermits
pretests10310013pretests
pretexts1735603pretexts
pretrims1238983pretrims
pretties10615133pretties
preunite1039573preunite
preunites1138933preunites
prevails1337663prevails
prevents133012293prevents
previsits1446793previsits
prexies163415003pr_exies
priedieu1153983priedieu
priedieus1242943priedieus
priests93810863prie_sts
probits112712573pr_obits
profits122911243pr_ofits
pundits10379293p_undits
readies83324713_readies
readmits1136653_readmits
rebaits9312573_rebaits
recits83621353_r_ecits
redias74523603_r_edias
redips93713843_r_edips
reedier83815303_reedier
reediest92815423_reediest
reedify1465763_reedify
reedily1179613_reedily
reeding94124133_reeding
reedings103510363_reedings
reedited10310083_reedited
reeds65430903_reed__s
reemit8717223_reemit_
reests64618893_ree_sts
refits94017653_r_efits
reknits1137073_reknits
remedies11310553_remedies
remits85622943_r_emits
resits64725563_r_esits
subedits1146713subedits
trendies9312213trendies

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.406440125.6
2DLD Change Limit1461621487.93618417.6
3Display Results1481480.0632349.2
 (SQL Overall)1786911488.40521260.1
 
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.