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

88 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
biriani94564(None) 
birianis1056341birianis
biryani1244031biryani
bikini12418912biki_ni
biryanis1344042biryanis
airing74927503airi_ng
airman82414223airman_
bani65334953b___ani
banian8315383banian_
banians9312033banians
bargain1079063bargain
baring95135853bari_ng
barman103519703barman_
biali73419073b__iali
biding104720793bidi_ng
biking135018173biki_ng
bikinis13346203biki_nis
biliary1238213biliary
biplane1139033biplane
birding114014923birding
birdman1236673birdman_
birling104317053birling
birring103713063birring
biting95321823biti_ng
blini75519273b_li_ni
borane84620213bor_ane
boring94724873bori_ng
brain76229383b_rain_
brains85125473b_rains
brainy114815643b_rainy
bran65740383b_r_an_
brand85124493b_r_and
brank115222283b_r_ank
brans75437433b_r_ans
brant74742173b_r_ant
bravi104715753b_r_avi
briar75718153b_ria_r
briard94311293b_riard
briars84814823b_riars
briary114912003b_riary
brigand1136643brigand
brin67038193b_ri_n_
brine75132273b_ri_ne
bring85528503b_ri_ng
brink116122003b_ri_nk
brins75533973b_ri_ns
briny104719663b_ri_ny
briony1149043b_riony
brisant9312683brisant
buran75225303bur_an_
burans85019303bur_ans
burial84117623buria_l
burials93612083burials
burin75626063buri_n_
burins84221893buri_ns
durian7312003durian_
durians839573durians
firing104021723firi_ng
firman112211343firman_
firmans12238523firmans
hariana10310243hariana
hiring104421603hiri_ng
iring66025423_iri_ng
kirigami1551553kirigami
mirin75023153miri_n_
miring93723803miri_ng
mirins83918903miri_ns
nirvana1042843nirvana
nirvanic1342253nirvanic
parian83223963parian_
parians93519733parians
pirana8713263pir_ana
priapi1037923_priapi
rani46640103__r_ani
riant55833153__riant
ripieni944113ripieni
simian8811163simian_
simians959203simians
siring75128313siri_ng
timpani11266153timpani
tiring74023093tiri_ng
titian62512663titian_
titians72710453titians
variant10316803variant
virion9310683virion_
virions1039873virions
wiring104521023wiri_ng
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.1561145455.1
2DLD Change Limit134027887.75017293.8
3Display Results88880.0302933.3
 (SQL Overall)178691887.93622516.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.