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

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

78 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
basmati114823(None) 
basmatis1247341basmatis
mammati10398372mammati
abomasi11115493abomasi
acmatic13311703_acmatic
assai5711543_assa_i
astatic9514193_astatic
baccate131011263baccate
badman113813853badma_n
bagman114613823bagma_n
balata8614683ba_lata
bandmate1347973bandmate
banzai1737653banza_i
barbate11314543barbate
barmaid1238213barmaid
barman103519723barma_n
basal75722283bas_a_l
basalt83519583bas_alt
basaltic1245153basaltic
basalts9358963basalts
baseman1138553basema_n
basenji1641943basenji
basest84720493basest_
bashaw14349303basha_w
bashaws15347713bashaws
basket125722913basket_
baskets135111833baskets
basset85225383basset_
bassets96414823bassets
bassett94213863bassett
bassi77019323bas__si
bast66362413bas__t_
bastard103012423bastard
baste74829983bas__te
basts75936933bas__ts
bathmat14510143bathmat_
bathmats1545933bathmats
batman105214073batma_n
batsman1157993batsma_n
bayman133712713bayma_n
bedmate1239433bedmate
bemata10411693b_emata
besmut10310653besmut_
besmuts1134683besmuts
bismuth1443723bismuth
bistate9313823bistate
bromate11313553bromate
busman10310253busma_n
caseate9314783caseate
casemate1239843casemate
cassata938143cassata
castrati1048643castrati
dalmatic1348693dalmatic
gasman92911753gasma_n
haematic151310223haematic
haematin13148893haematin
hamate113319833ha_mate
hastate10313913hastate
hazmat20312273hazmat_
hazmats2136603hazmats
kismat123011683kismat_
kismats13257843kismats
magmata1237463magmata
magmatic1548403magmatic
mammate104411273mammate
miasmata1244503miasmata
miasmatic1545633miasmatic
mismate111415353mismate
osmatic11179993_osmatic
palmate113215233palmate
plasmatic1547223plasmatic
ramate83921693ra_mate
sati45539333__s_ati
smalti84111193__smalti
tamari8313413ta_mari
wasabi1154643was_abi
yasmak1534603yasma_k
yasmaks1633653yasmaks

Search took 8 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.420425454.8
2DLD Change Limit134027786.78319759.3
3Display Results78780.0302600.0
 (SQL Overall)178691787.23324705.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.