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

61 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
alerts6441822(None) 
alert54740651alert_
averts95715241averts
abets75621672abe_ts
aborts84916182aborts
adepts9117102adepts
adverts11308512adverts
agents74816292agents
agers65027852ager_s
aglets73915682agle_ts
airts55626342a_irts
alants67722022alants
alarms85913052alarms
alders74218422alder_s
alecs76620732ale_cs
alefs87319662ale_fs
alephs1136532alephs
alerted82512222alerted
alerter72111512alerter
alertest8310172alertest
alertly1046792alertly
ales47067102ale__s
allots64019172allots
alters64924222alter_s
alts46639902al__ts
aments85219802aments
apers76629132aper_s
arts49650262a__rts
asserts74311792asserts
avers85127312aver_s
avert86029492avert_
balers85626932baler_s
bleats85518612bleats
blets75324942ble_ts
blurts84412642blurts
cherts115617232cherts
cleats84919312cleats
clefts114610162clefts
clerks12458842clerks
elects83315002elects
everts94514892everts
exerts133712292exerts
fleets96915062fleets
flirts95411482flirts
galeres83514322galeres
gleets75315052gleets
halberts1335962halberts
halers94926912haler_s
inerts64517022inerts
leets54927122_leets
lefts86517812_lefts
lets47147942_le_ts
nerts55924982_nerts
palets85122312pale_ts
pleats85218592pleats
sleets64318872sleets
talents7312012talents
talers64628142taler_s
valets93715622vale_ts
verts85724732_verts
walers94824462waler_s

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 Filter178691825510.1101624463.6
2DLD Change Limit82551612.81329346.2
3Display Results61610.0163812.5
 (SQL Overall)178691612.93960799.9
 
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.