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

135 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
atlatls74477(None) 
atlatl637871atlatl_
ablates92416902ablates
alates64833962a_lates
atlantes838552atlantes
atlas55821582atla__s
atlases72410642atlases
aals49941143a__a_ls
abates85825033a_bates
abatis84317933a_batis
ablate82219213ablat_e
ablated102513443ablated
ablator939843ablator
ablators1069873ablators
ablauts936083ablauts
abwatts1233403abwatts
acetals93411353acetals
actuates10310313actuates
acylates1339743acylates
adulates9311913adulates
aerates74627493aerates
afflatus1442683afflatus
agates76121343a_gates
aglets73915683aglet_s
agnails837003agnails
agnates82813193agnates
alamos8415003a_lamos
alands75418373a_lands
alans55636173a_la_ns
alants67722023a_lants
alanyls1084353a_lanyls
alarms85913053a_larms
alas46358123a_la__s
alate55340323a_lat_e
alated75625143a_lated
albatas938373albatas
aldols7109713a_ldols
alkyls13465723a_lkyls
allays94313743alla_ys
allots64019173allot_s
alls46740923a_l__ls
allyls9437273a_llyls
altars64518153alta_rs
altos55822953a_l_tos
alts46639903a_l_t_s
amatols938183a_matols
anlaces92313733anlaces
anlages82414113anlages
anlas55626933anla__s
anlases72514903anlases
annals66415923anna_ls
annates72415423annates
aplites9314933aplites
appalls11337743appalls
appals104812943appa_ls
argals75517713arga_ls
arhats9312973arhat_s
assails769093assails
astrals75515243astra_ls
atabals938413atabals
atalayas1144783atalayas
ataps76414833at_a_ps
athletes1157883athletes
atmans84413963atma_ns
atmas75721013atma__s
atolls65511353at_olls
attacks13126943attacks
attains7310983attains
attars64515313atta_rs
avails939693a_vails
aviates10313063aviates
axolotls1541783axolotls
balatas9311833balatas
blats75132503_blat_s
catcalls1238323catcalls
catfalls1347063catfalls
cattails1038553cattails
delates83526283delates
dilates83220663dilates
eclats8313033eclat_s
elates65032363_elates
fallals103310193falla_ls
flails94313003_flails
flatly123110213_flatly
flats86429743_flat_s
flatus94310783_flatus
folates103218453folates
gallates92815523gallates
gelates83219583gelates
gelatis83313513gelatis
gelatos83111513gelatos
halals95018313hala_ls
lalls55324133__lalls
laths86022403__laths
lats45962703__lat_s
malates93522603malates
oblates91913243oblates
palatals1037773palatals
palates93624933palates
plates85432243_plates
plats75531373_plat_s
platys11459853_platys
ratals64219583rat_a_ls
rattails837133rattails
relates73731433relates
salals65120083sala_ls
satiates8314633satiates
slates64934063_slates
slats55436903_slat_s
solates73523853solates
splats84817303splat_s
stalls64019933st_alls
states64337083st_ates
stats55933363st_at_s
status65515213st_atus
steals64020063stea_ls
stoats65117483stoat_s
stratas73013583stratas
straths102711723straths
stratus73011733stratus
taels56822073_t_aels
tails55634193_t_ails
talars66021683tala_rs
talas55935893tala__s
tallols73311363tallols
talls55133433_t_alls
tamals84116633tama_ls
tates55444983_t_ates
tats46858133_t_at_s
teals56234133_tea_ls
teats55636813_teat_s
totals63115163_totals
trails64622513_trails
trawls94412393_trawls
twats86616603_twat_s

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.403443402.0
2DLD Change Limit1340271357.34618244.9
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.79522923.8
 
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.