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

107 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
between123468(None) 
atween9166612_atween
betaken13438282betaken
betoken13386502betoken
beweep13147252be_weep
etwee84115332_etwee_
etwees9348792_etwees
tween84413742__tween
baleen8613053b_aleen
batmen104414303bat_men
batsmen1146883batsmen
batten85217123bat_ten
beadmen12299453beadmen
beaten84617063be_aten
bedemen12910183bedemen
bedewed1437153bedewed
bedizen1935943bedizen
beebee10313063beebee_
beebees1138013beebees
beechen14367703beechen
been65335783b___een
bejewel1953043bejewel
belleek1347243belleek
bellmen1138143bellmen
bemean10410683be_mean
bendee94121023bendee_
bendees103913863bendees
benzene1836343benzene
berseem1166463berseem
bescreen1244303bescreen
beseem1069083be_seem
bestrewn1343323bestrewn
betaine9413783betaine
betake124512703betake_
betakes134212523betakes
betaxed17307023betaxed
betel74419903bet__el
betels84515063bet_els
bethel1169643bet_hel
bethels1238533bethels
bethorn1238643bethorn
betide95115973betide_
betided114810203betided
betides104915263betides
betime105914833betime_
betimes115114413betimes
betise85616273betise_
betises94816123betises
betokens14324573betokens
beton76022063bet__on
betted94721163bet_ted
better84723703bet_ter
bettered113011833bettered
betters94422093betters
betwixt1943733betwixt
beweeps1494563be_weeps
bewept13410323be_wept
bitchen14349733bitchen
bitten84715123bit_ten
bittern94810683bittern
bitumen1134503bitumen
boreen8314313b_oreen
bowmen1399853b_owmen
brethren1343783brethren
buckeen1536703buckeen
burweed1347823burweed
butene8312623but_ene
ethene93312923_ethene
ketene106613003ket_ene
lateen64014863lat_een
lethean1037093lethean
netizen1635883netizen
outseen72712333outseen
outweep1236673outweep
overween14218513overween
peebeen1143903peebeen
peetweet1344973peetweet
peewee11311963peewee_
peewees1236803peewees
pewee10319973pe_wee_
pewees11311393pe_wees
poteen83514263pot_een
potheen12257893potheen
potteen9319673potteen
preteen939873pret_een
ratteen7329113ratteen
regreen8309043regreen
reseen64318413re_seen
retaken113911803retaken
retene69224273ret_ene
sateen63815013sat_een
seaweed11108813seaweed
settee63721023settee_
settees73513633settees
teen45938203__t_een
terreen7257573terreen
treen55622753__treen
twee76827083__twee_
tweed94915093__tweed
tweens9489843__tweens
tweeny12477003__tweeny
tweet84823983__tweet
ween75835463___ween
weewee12310083weewee_
weeweed1435183weeweed
weewees1336563weewees
yestreen1144593yestreen

Search took 7 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.423422437.4
2DLD Change Limit1340271075.95322514.2
3Display Results1071070.0303566.7
 (SQL Overall)1786911076.40627894.3
 
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.