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

53 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
batik1161473(None) 
batiks1239371batiks
battik1238091battik
abatis84317932abatis
back125535762ba_ck
bail65042802ba_il
bait66556002ba_it
baith108023132baith
baits76630582baits
balk105132222ba_lk
bani65334962bani_
bank105835752ba_nk
baric96125692baric
bark106242152ba_rk
basic96220522basic
basil75122272basil
basin75026922basin
basis75429862basis
bask105131422ba_sk
bat510988952bat__
batch124620102batch
bate66552422bat_e
bated85935532bated
bates75846342bates
bath95940082bat_h
bathe105822882bathe
baths105922922baths
batiked1435962batiked
bating95132252bating
batlike133311882batlike
baton75822422baton
bats66962332bat_s
batt65053872bat_t
battiks1337142battiks
batts76727562batts
battu75216612battu
batty105422242batty
baulk114914332baulk
bawtie113812142bawtie
beatnik1344862beatnik
haik115526982ha_ik
kamik105011552kamik
lati46438272lati_
matin75132852matin
paik105726802pa_ik
patin76832852patin
patio74426352patio
ratio55227582ratio
sati45539332sati_
satin55935222satin
satis55633682satis
shtik123210962shtik
vatic10316422vatic

Search took 2 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.330541487.9
2DLD Change Limit53800531.54634799.5
3Display Results53530.0163312.5
 (SQL Overall)178691531.89294445.6
 
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.