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

46 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
biryani124403(None) 
biriani945641biriani
biryanis1344041biryanis
birianis1056342birianis
airman82414233airman_
bani65334963b___ani
banyan1139483banyan_
banyans1237913banyans
bargain1079063bargain
barman103519723barman_
baryon111211613baryon_
baryonic1546203baryonic
baryons121010473baryons
biali73419073bi__ali
bikini12418913bi_kini
biplane1139033biplane
birding114014923birding
birdman1236673birdman_
birling104317053birling
birring103713063birring
borane84620213bor_ane
brain76229383b_r_ain
bran65740383b_r_an_
brand85124493b_r_and
brank115222283b_r_ank
brans75437433b_r_ans
brant74742173b_r_ant
bravi104715753b_r_avi
brigand1136643brigand
brisant9312683brisant
bryony1435833b_ryony
buoyant1246263buoyant
buran75225303bur_an_
burans85019303bur_ans
burying133413913burying
firman112211353firman_
firmans12238523firmans
minyan1138173minyan_
minyanim1542973minyanim
minyans1237263minyans
nirvana1042843nirvana
nirvanic1342253nirvanic
pirana8713263pir_ana
rani46640113__r_ani
timpani11266153timpani
zingani1744813zingani

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.390458182.1
2DLD Change Limit134027467.01319111.2
3Display Results46460.0162875.0
 (SQL Overall)178691467.41924085.6
 
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.