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

158 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
abwatt1141067(None) 
abwatts1233401abwatts
abaft10318062ab_aft
abate76627842ab_ate
ablate82219212ablate
ablaut8313262ablaut
await85524492a_wait
batt65053872_b_att
watt75545412__watt
aba512850953ab_a__
abaca95118043ab_aca
abaci94718843ab_aci
aback134816173ab_ack
abaka114313823ab_aka
abamp11310603ab_amp
abas68642083ab_a_s
abase76023483ab_ase
abash106016513ab_ash
abated95918453ab_ated
abater85518123ab_ater
abates85825033ab_ates
abatis84317933ab_atis
abator84512723ab_ator
abattis9297823ab_attis
abaya104413173ab_aya
abba810522653abba__
abbacy1536623abbacy
abbas95918643abba_s
abbot9318453ab_bot
abbots1039283abbots
abduct11108543abduct
abeam9316533abea_m
abet610547943ab__et
abets75621673ab_ets
abeyant1248083abeyant
abject17137703abject
ablated102513443ablated
ablates92416903ablates
ablator939853ablator
ablauts936083ablauts
ablaze17239833ablaze
ablest84721833ablest
aboard9312613aboard
abort76133583ab_ort
aborts84916183aborts
about75229083ab_out
abrade9313053abrade
abreact11310823abreact
abreast9311273abreast
abrupt1039943abrupt
absent84016993absent
abut66834953ab__ut
abuts75417073ab_uts
abvolt11169833abvolt
acuate8315633acuate
adapt81218553a_dapt
adnate72913483adnate
aerate64830553aerate
agate66525153a_gate
aghast105711373aghast
agnate73314883agnate
alant55742293a_lant
alate55340333a_late
albata839333albata
alway116113923alwa_y
always12409133always
anatto6139913a_natto
annatto7144153annatto
ansate64517863ansate
apart74330673a_part
arhat8327093arha_t
arhats9312973arhats
arnatto7145073arnatto
arrant6623253arrant
askant10412713askant
aslant6317753aslant
aswarm11107913aswarm
athwart1348683athwart
atlatl637873atlatl
att35454653___att
atwain937813atwain
aurate64426473aurate
avant86224663a_vant
avast85519363a_vast
aviate9315203aviate
awa611939673a_wa__
awaits96411953a_waits
awake125014783a_wake
award97118043a_ward
aware86420023a_ware
awash116613163a_wash
away108024223a_wa_y
babbitt1038033babbitt
baht96740013_b_aht
bait66556003_b_ait
balata8614683balata
basalt83519583basalt
bast66362413_b_ast
bat510988953_b_a_t
bate66552423_b_ate
bath95940083_b_ath
bats66962333_b_ats
batts76727563_b_atts
battu75216613_b_attu
batty105422243_b_atty
bawty135614103baw_ty
beast76338643_beast
beat66168303_bea_t
beats76042243_beats
beaut75135213_beaut
bitt65545813_b_itt
blast76532573_blast
blat66550953_bla_t
blate75933783_blate
blats75132503_blats
boart78835933_boart
boast75935703_boast
boat66360313_boa_t
boats75635153_boats
bott66548573_b_ott
bract96332723_bract
brant74742173_brant
brat66055543_bra_t
brats75336013_brats
bratty1159683_bratty
britt75732233_britt
butt65143743_b_utt
bwana10310243_bwana
gabbart1248883gabbart
habitat12411053habitat
labiate91313573labiate
matt65752663__matt
nanowatt1144453nanowatt
oblast8613663oblast
oblate82214743oblate
rabat72832223rab_a_t
rabato83413263rab_ato
rabats83116223rab_ats
sabbat10314713sabba_t
sabbath1445393sabbath
sabbats1138633sabbats
scatt76030093_scatt
swart86234643_swart
swat77244443_swa_t
swath115920383_swath
swats85726863_swats
thwart12311683thwart
twat75831513_twa_t
twats86616603_twats
upwaft1444943upwaft
waft106139003__waft
wait75553693__wait
want76156173__want
wart77866083__wart
wast75655853__wast
wat67378923__wa_t
wats77555883__wats
watts86923093__watts

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.376475242.0
2DLD Change Limit1127161584.76623650.0
3Display Results1581580.0463434.8
 (SQL Overall)1786911585.18834443.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.