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

54 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
betise8561627(None) 
betide95115971betide
betime105914831betime
betises94816121betises
baptise1139552baptise
batiste939742batiste
bedtime1236972bedtime
beige81515382be_ige
bekiss1236372bekiss
belie75630382beli_e
belies84631052belies
belike124616282belike
belive115415302belive
bemire103312802bemire
bemist105216952bemist
bemuse1038942bemuse
berime105317332berime
beside95114612beside
betaine9413782betaine
betake124512702betake
betas75528762betas_
beths105519222beths_
betided114810202betided
betides104915262betides
betimes115114412betimes
bets67051442bet_s_
bevies114017302bevies
bise66437102b__ise
braise84318752braise
bruise83412872bruise
cerise84822042cerise
demise94618322demise
devise104215752devise
fetish12310372fetish
ketose105711812ketose
metis75025902metis_
metisse936502metisse
obelise9310172obelise
peise75825772pe_ise
petite84320652petite
poetise9314042poetise
remise84221952remise
rerise64325632rerise
retie55735302reti_e
reties65436192reties
retile65929672retile
retime85321802retime
retine66237332retine
retire64927012retire
retuse66617222retuse
revise94019742revise
seise54727852se_ise
setose65114772setose
yetis85418392yetis_

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.346516448.0
2DLD Change Limit82551542.21637252.3
3Display Results54540.0163375.0
 (SQL Overall)178691542.57869313.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.