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 “alarm” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
alarm7662142(None) 
alar46340071alar_
alarms85913051alarms
alarum85411981alarum
alary86123441alary
acari75020282acari
afar76720782afar_
afars85716512afars
agar58726412agar_
agars66120642agars
aglare7312422aglare
ajar116217702ajar_
ala312463602ala__
alack114820062alack
alae45643752ala_e
alamo7418142alamo
alan46844082ala_n
aland65526412aland
alane56135612alane
alang66023512alang
alans55636172alans
alant55742292alant
alarmed1037732alarmed
alarums9408922alarums
alas46358122ala_s
alate55340322alate
album92312652album
alert54740652alert
algum82711762algum
altar55520642altar_
altars64518152altars
alum65227612al_um
apart74330672apart
arm58449622__arm
asarum84610912asarum
aswarm11107912aswarm
award97118042award
aware86420022aware
barm86739602_barm
blam86131702bla_m
blare75826232blare
charm126124662charm
claim95616912claim
clam86332292cla_m
claro75018692claro
clary105719612clary
farm95934532_farm
flam96333292fla_m
flare84823632flare
glam76529342gla_m
glare65222952glare
glary96018542glary
harm95637792_harm
inarm7314422inarm
kalam11315112kala_m
laari54415712laari
lam57666712_la_m
lar37967532_lar_
lard56742002_lard
lari45839152_lari
lark85733862_lark
lars46956572_lars
larum74317972_larum
malar76424442malar_
malars85020682malars
plasm94114632plasm
rearm75923562rearm
salaam8711012salaam
salary9515212salary
slam67737972sla_m
smarm95517602smarm
swarm106218832swarm
talar56225382talar_
talars66021682talars
tharm105916642tharm
unarm7314452unarm
warm95935672_warm

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.0931921408.6
2DLD Change Limit53800771.90628226.7
3Display Results77770.0302566.7
 (SQL Overall)178691772.02988068.5
 
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.