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

139 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
abate7662784(None) 
abase76023481abase
abated95918451abated
abater85518121abater
abates85825031abates
ablate82219211ablate
agate66525141agate
alate55340321alate
bate66552421_bate
aba512850952aba__
abaca95118042abaca
abaci94718842abaci
aback134816172aback
abaft10318062abaft
abaka114313822abaka
abamp11310602abamp
abas68642082aba_s
abased96514992abased
abaser86414342abaser
abases85720772abases
abash106016512abash
abaters95115192abaters
abatis84317932abatis
abator84512712abator
abaya104413172abaya
abbe87627182ab_be
abele76323252abele
abet610547942abet_
abets75621672abets
abide86223702abide
ablated102513442ablated
ablates92416902ablates
ablaze17239832ablaze
able66340532ab_le
abode85518812abode
above105414322above
abrade9313052abrade
abuse77119562abuse
abut66834952abut_
abuts75417072abuts
abwatt11410672abwatt
abye97921002ab_ye
acuate8315632acuate
acute74720362acute
adage7414052adage
adnate72913482adnate
aerate64830552aerate
agape85614842agape
agates76121332agates
agave95314032agave
agaze156113662agaze
agnate73314872agnate
alae45643752ala_e
alane56135612alane
alated75625142alated
alates64833962alates
albata839332albata
albite8313302albite
amaze166016602amaze
ambage11510592ambage
ansate64517862ansate
antae56828292antae
ante46538902a_nte
apace94718382apace
arame75026622arame
arbute8311042arbute
arete56031352arete
ate37059242__ate
aubade939222aubade
aurate64426472aurate
aviate9315202aviate
awake125014782awake
aware86420022aware
axite125218252axite
azote144416342azote
babe86835812_babe
bade75140882_bade
bake105637512_bake
bale66353842_bale
bane65250422_bane
barbate11314542barbate
bare65460522_bare
base64847022_base
baste74829982baste
bat510988952_bat_
bated85935532_bated
bates75846342_bates
bath95940082_bath
bathe105822882_bathe
bats66962332_bats
batt65053872_batt
bite66546992_bite
blate75933782blate
bute66739672_bute
byte96521812_byte
carate84734002carate
cate66254592_cate
crate76537402crate
date56443322_date
debate94419192debate
elate55335882elate
enate54428142enate
fate75444282_fate
gate55746572_gate
grate64932882grate
hamate113319822hamate
hate78450172_hate
irate55627982irate
karate105320922karate
labiate91313572labiate
lanate6421262lanate
late47560482_late
lobate82915242lobate
malate84624552malate
mate65154212_mate
oblate82214742oblate
orate55133302orate
ovate84214392ovate
palate84226782palate
pate65350462_pate
plate74635112plate
prate75135982prate
quate144521412quate
rabat72832222rabat_
rabato83413262rabato
rabats83116222rabats
ramate83921682ramate
rate45458762_rate
rebate84424102rebate
sate45556102_sate
savate9313782savate
skate94721542skate
slate55438282slate
spate74731582spate
state56237332state
tate44748602_tate
tubate82813172tubate
urate55432162urate
vacate11314552vacate

Search took 3 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.186960704.3
2DLD Change Limit538001392.14325105.0
3Display Results1391390.0463021.7
 (SQL Overall)1786911392.37575238.3
 
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.