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

267 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
uralite7171410(None) 
ruralite848961ruralite
uralites82112721uralites
uranite72515691uranite
aurality1139222aurality
egalite8311562egalite
granite82017082granite
halite93624232_halite
hyalite13229472hyalite
marlite92917072marlite
orality101111682orality
praline93019742praline
ratite65022422_ratite
ruralise839642ruralise
ruralites947942ruralites
rurality1137402rurality
ruralize1739232ruralize
unakite1138742unakite
unalike11311532unalike
uralitic10158452uralitic
uranide82212092uranide
uranites82514642uranites
urate55432162ura__te
urbanite1097182urbanite
urnlike1136712urnlike
urolith1048782urolith
aerolite8315053aerolite
alate55340323__alate
albite8313303__albite
alike95523963__alike
aline57243153__aline
alit46155693__alit_
alive85722513__alive
analcite1049333analcite
anality10313633anality
analyte10158813analyte
apatite9312963apatite
aplite8316393_aplite
arabize1849343arabize
arenite71017713arenite
armlike1348553armlike
auralities10410223auralities
aurate64426473aura__te
axite125218253__axite
barite84224813_barite
blite76225353__blite
boracite1249193boracite
braille939713braille
braise84318753bra_ise
braize174113113bra_ize
braunite1047253braunite
brawlie12198153brawli_e
bubaline1247163bubaline
burkite1337003bur_kite
calcite11413783_calcite
carline93923613carline
chalice14311043chalice
crablike1636023crablike
craniate10312563craniate
crate76537403cra__te
crinite9513633crinite
cryolite1347503cryolite
curarine10610703curarine
curarize1988853curarize
curate85226243cura__te
curative13310403curative
curite85222943cur__ite
cyanite122710763cyanite
dacite91115883_dacite
dealate83617843dealate
dragline1036843dragline
duality1147963duality
dualize1759763dualize
durative1239073durative
egalites9310503egalites
elite56230183__elite
eradiate91911753eradiate
eremite9312833eremite
erudite838483erudite
fayalite1447053fayalite
flite85424963__flite
fragile1147843fragile
frailty1335663frailty
fraise94214913fra_ise
goalie7413153goali_e
gracile102512603gracile
gradate9511223gradate
gradine93317033gradine
granita82111303granita
granites92116363granites
granulite1046923granulite
graphite1447153graphite
grapline1138723grapline
grate64932883gra__te
gratine84719193gratine
gravity1437183gravity
halide103417993_halide
halites103221193_halites
haplite12310703haplite
hoplite12311073hoplite
hyaline132310723hyaline
hyalites14208833hyalites
illite63414913_illite
iolite63221973_iolite
irate55627983ira__te
krait94726773kra_it_
kraits104912203kra_its
kryolite1544493kryolite
kyanite14237313kyanite
lite47054543___lite
localite101411543localite
malate84624553_malate
malice104818483_malice
maline84529083_maline
marline93320953marline
marlites103415263marlites
marmite112413993marmite
mealie82519803meali_e
moralise10314913moralise
morality131110333morality
moralize19313923moralize
mullite9313013mullite
muralist10312983muralist
muralists1148153muralists
oarlike113411193oarlike
oolite63319603_oolite
opaline9412483opaline
oralism9513763oralism
oralist7619633oralist
oralists8611793oralists
oralities91214113oralities
orate55133303ora__te
ovality1377593ovality
oxalate1457623oxalate
palate84226783_palate
parakite14410423parakite
parasite10314843parasite
partite9317133partite
pealike131211273pealike
pearlite1039433pearlite
pelite84323003_pelite
penlite9313243penlite
perlite9317313perlite
plurality1444613plurality
pluralize2045773pluralize
polite83625073_polite
praise84419413pra_ise
pralines102217723pralines
prate75135983pra__te
prelate9519693prelate
prelife1279943prelife
prolate9419793prolate
proline92321593proline
purline93516533pur_line
quality1938563quality
radiate83416313_radiate
raise54828053_ra_ise
raita54623073_ra_ita
rale45050563_ral__e
ralline73518413_ralline
rallye95110163_rallye
ramate83921683_ramate
ramie75027823_rami_e
rapine85023083_rapine
rarity93615493_rarity
rate45458763_ra__te
ratine65131823_ratine
ratites74920683_ratites
ratlike113912353_ratlike
ratline74517803_ratline
ravine95522223_ravine
raylike14269253_raylike
realise73021813realise
reality10313573reality
realize162717083realize
recite83625113_recite
relate64033633_relate
reline65434353_reline
relit55340683_relit_
relive95120783_relive
resite64128453_resite
rite45849453_r__ite
ruglike1236283ruglike
ruralised1046593ruralised
ruralises939123ruralises
ruralism1048533ruralism
ruralist8311703ruralist
ruralists947633ruralists
ruralities1048563ruralities
ruralized1947903ruralized
ruralizes1858773ruralizes
saline65132703_saline
saltie63422423_saltie
salute64418023_salute
samite83020603_samite
smaltite1046903smaltite
sodalite9109593sodalite
stylite10219613stylite
surflike1535933surflike
surplice1246203surplice
taxite13511303_taxite
tealike111111083tealike
tillite7313563tillite
trait56940843tra_it_
traits65121983tra_its
tramline10311383tramline
traplike1437653traplike
trapline10411863trapline
trilith10310513trilith
triplite1039103triplite
trite54730033tr__ite
troilite849543troilite
turflike1534443turflike
turgite837973tur_gite
ulexite1445723ulexite
ululate749963ululate
umangite1144823umangite
unagile838283unagile
unakites1237543unakites
unite54828383u__nite
unlike102614063u_nlike
unlit55025463u_nlit_
unlive92712333u_nlive
unpolite1049173unpolite
unreality1246323unreality
unwhite1336813unwhite
uplit76020803u_plit_
upraise9158603upra_ise
uprate83916543upra__te
uracil8311543uraci_l
uracils939373uracils
uraei53016083uraei__
urania62516123urani_a
uranias72113813uranias
uranic82315183urani_c
uranides92211283uranides
uraninite946743uraninite
uranism91112513uranism
uranitic10148683uranitic
uranium9610023uranium
urare56322553ura__re
urari54619963urari__
uraris63817273urari_s
urase54624683ura__se
urates65027763ura__tes
uratic83016353urati_c
urbanise10107283urbanise
urbanites11105913urbanites
urbanity13105303urbanity
urbanize19106733urbanize
ureide7310363ur_eide
uridine81311213uridine
urinate7315363urinate
urine55026593ur__ine
uroliths1154923uroliths
ursine64114123ur_sine
utilise749063utilise
utility1038703utility
utilize1648803utilize
valine94623093_valine
valise92917643_valise
warlike142410473warlike
wraith1258603wra_ith
write85522833wr__ite
wurtzite2042003wurtzite
zaratite1747793zaratite
zeolite1638903zeolite

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.1401276364.3
2DLD Change Limit1340272677.56317721.4
3Display Results2672670.1102427.3
 (SQL Overall)1786912677.81322871.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.