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

168 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
adjust144717(None) 
adjusts1544501adjusts
adust64117451ad_ust
adduct1087372adduct
adjunct1753572adjunct
adjure1435832adjure
adjusted1743602adjusted
adjuster1644342adjuster
adjustor1643112adjustor
adult63520652ad_ult
august739202august
dust57142532_d_ust
just115433342__just
readjust1644452readjust
unjust1337872unjust
abduct11108543abduct
abject17137703abject
abjure1536733abjure
ablest84721833ablest
ablush1147223ablush
about75229083abou_t
abrupt1039943abrupt
abuse77119563a_buse
abut66834953a_bu_t
abuts75417073a_buts
accost101112263accost
accurst1146243accurst
accuse103411033accuse
acquest1837173acquest
acquit17610323acquit
adapt81218553ad_apt
adapts9107813adapts
addict10711203addict
addrest958623addrest
adds67622453ad_ds_
adduce1076453adduce
adducts1174603adducts
adept81219643ad_ept
adepts9117103adepts
adieus739633adieus_
adios65822863adios_
adit56443653ad__it
adits66523713adits_
adjoin14107273adjoin
adjoint15108283adjoint
adjourn1563423adjourn
adjudge1742603adjudge
adjuncts1842453adjuncts
adjured1634873adjured
adjurer1534803adjurer
adjures1536223adjures
adjuror1542883adjuror
adjusters1744143adjusters
adjusting1843823adjusting
adjustive2043233adjustive
adjustors1743203adjustors
adjutant1664453adjutant
adjuvant1983023adjuvant
admass957143admass
admit8319493ad_mit
admits9411413admits
admixt1637333admixt
adopt81219743ad_opt
adopts998083adopts
ados57633513ad_os_
adrift10313113adrift
adroit7518783adroit
ads49755733ad__s_
adults7299953ad_ults
adunc837433ad_unc
advect12309123advect
advent102613753advent
advert103215773advert
advise10139223advise
adzes155913803adzes_
adzuki2042513adzuki
ageist7315383ageist
aghast105711363aghast
agist66325583a_gist
airest63825263airest
ajuga1335883a_juga
alist56136783a_list
almost81014433almost
ambush1336113ambush
amidst94913233amidst
amount8414483amount
amus65529613a_mus_
amuse75920833a_muse
anenst63514983anenst
angst6415493a_ngst
ankus91410683ankus_
ankush13114433ankush
anus47131113a_nus_
aorist64827873aorist
aptest82917513aptest
arcus76918863arcus_
argus66716543argus_
arouse65019983arouse
arrest63722633arrest
artist64125543artist
ascus75013583ascus_
assist6314603assist
attest62618613attest
aunt46553653a__unt
aurist65027253aurist
autist64324943autist
avast85519363a_vast
avaunt959603avaunt
baddest112611143baddest
bust65947783__bust
crust75827663_crust
dadaist9310103dadaist
daunt65929083_daunt
daut56443563_dau_t
dauts67822243_dauts
degust8310253degust
deist64633593_deist
didst74619613_didst
doest65829523_doest
dost57248353_d_ost
doubt8720093_doubt
douse66329723_douse
drest65530343_drest
druse64817663_druse
duct75735463_d_uct
duet56446263_d_uet
duit56241583_d_uit
dunt55746873_d_unt
durst66125173_durst
dusk95724153_d_usk
dusts65923563_d_usts
dusty96018323_d_usty
educt85017103ed_uct
faddist12289643faddist
gust55240703__gust
haddest122711993haddest
hadjes175210403hadjes_
hadjis17439633hadjis_
hadst93220223had__st
idlest74014863idlest
jest116738503__jest
joust125122293_joust
jujuist1343073jujuist
jujus11347463jujus_
jus106930223__jus_
justs124918263__justs
jut105944013__ju_t
juts115930163__juts
locust85312343locust
lust47442603__lust
maddest112311213maddest
misadjust1952123misadjust
must65145443__must
oddest81710863oddest
odist6421913od_ist
oust46747443__oust
preadjust1943603preadjust
radius73914863radius_
readjusts1743043readjusts
robust8310433robust
roust55532063_roust
rust45544913__rust
saddest92412383saddest
sadhus10298463sadhus_
sadist74221353sad_ist
sawdust1154533sawdust
thrust91911893thrust
trust55426853_trust

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.1401276364.3
2DLD Change Limit1127161684.90622975.1
3Display Results1681680.0632666.7
 (SQL Overall)1786911685.10934975.7
 
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.