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

169 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
urtext133743(None) 
urtexts1433141urtexts
curtest9713962curtest
pretext1639662pretext
subtext1647652subtext
text116033932__text
unvext1658172unvext
urgent73816042urgent
aptest82917513aptest
ardent73022613ardent
argent74023663argent
armet76739453arme_t
arpent84822093arpent
arrest63722633arrest
artel56122743arte_l
artels66216233artels
artery9911453artery
artiest73121993artiest
artist64125543artist
attent62818323attent
attest62618613attest
brent75734133br_ent
buret77444013bur_e_t
burnet84326173burne_t
context163913433context
cortex15311473cortex_
crept95125893cr_ept
crest74632693cr_est
cruet74831843crue_t
curet75447643cur_e_t
current9313693current
curter85320083curte_r
curtesy1265833curtesy
curvet114720243curve_t
cutest85820143cutest
detect94217403detect
detent73624483detent
detest74122843detest
drest65530343dr_est
driest74722753driest
dryest104811123dryest
erect74129333er_ect
extent132714913extent
freest95318283freest
fret75845043fr_e_t
furthest1496863furthest
great66034243gr_eat
greet65835323gr_eet
gurnet74920873gurne_t
hurter93915853hurte_r
hurters103413643hurters
intent63122773intent
iratest7312483iratest
justest1449893justest
latent64124303latent
latest63822703latest
latex124717113latex_
lurex124816733lur_ex_
motet75641193mote_t
murex145517173mur_ex_
murkest133110203murkest
mutest84218053mutest
next116631083__next
obtect10129633obtect
obtest81213013obtest
octet7324063octe_t
oftest91212003oftest
orgeat7515033orgeat
orient6322533orient
outeat62824533outeat
patent84524923patent
pertest9317043pertest
portent93619643portent
potent84223353potent
prest75736353pr_est
pretest9517633pretest
pretexts1735603pretexts
prex135722973pr_ex_
prexy174611583pr_exy
priest84125423priest
protect11313633protect
protest9317533protest
purest84021933pur_est
purtiest102414113purtiest
quartet162814893quarte_t
reest54938093_reest
reft75141273_r_eft
rent46661243_r_ent
rest46459843_r_est
ret35982833_r_e_t
retest64028453retest
rex105740993_r_ex_
rudest74016313rudest
sext117338093__sext
stent55634513_stent
stet45947323_ste_t
street64125773street
subtest9513963subtest
subtexts1744903subtexts
surest65026763sur_est
surfeit10310343surfeit
surtax1337843surtax_
surtout7411683surtout
tartest72517533tartest
teat45963633__teat
tent46159863__tent
test48651623__test
tet39274993__te_t
texts125515043__texts
treat56240353tr_eat
tret46653533tr_e_t
tritest7315273tritest
truest64816193truest
turgent8712393turgent
turret63121853turre_t
unbelt83015693unbelt
unbent83216593unbent
unfelt92413463unfelt
unfixt16398423unfixt
unkent103116053unkent
unkept123710873unkept
unlet54133333unle_t
unmeet83815743unmeet
unmet74426393unme_t
unmixt15378703unmixt
unpent83117373unpent
unrent63219783unrent
unrest62918853unrest
unseat64221023unseat
unsent63820963unsent
unset54532433unse_t
unsex123512633unsex_
unsexy16296903unsexy
unwept11389813unwept
unwet84423173unwe_t
upbeat10911513upbeat
upsent83314063upsent
upset73222593upse_t
uptear896783uptear
uptilt8410803uptilt
uraei53016083urae_i
uraeus638793uraeus
urate55432163urate__
urates65027763urate_s
urea46528063ur_e_a
ureal56722683ur_eal
ureas55826013ur_eas
uredo65112993ur_edo
ureic74514463ur_eic
ureter6313203ureter
ureters7311823ureters
uretic82914353uretic
urge54722423urge__
urged75316033urge_d
urger64116473urge_r
urgers73313623urgers
urges64619913urge_s
urped84615283urpe_d
ute35335883u_te__
uteri51012983u_teri
utes45930883u_te_s
utter54218763utte_r
utters63817123utters
vertex1637373vertex_
vext146927763__vext
vortex1635923vortex_
wrest84925433wr_est
wriest94419713wriest
wryest12429113wryest

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161695.52320408.5
3Display Results1691690.0563017.9
 (SQL Overall)1786911695.96929936.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.