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

98 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
binal7532382(None) 
banal75925991banal
final83922031final
vinal85725811vinal
albinal937812albinal
anal48037522_anal
annal56520762annal
baal67033112b_aal
bal56662722b__al
basal75722282basal
basinal9310032basinal
benzal1739642benzal
biali73419072bi_ali
bialy105119322bi_aly
bias64738162bi_as
biaxal1536092biaxal
bill67239942bi_ll
bima86723832bima_
bimah127013272bimah
bimas95521742bimas
bin56658642bin__
binary11312222binary
binate8419772binate
bind76234512bin_d
bindi85617012bindi
bindle94516262bindle
binds86627472binds
bine66650862bin_e
biner75930692biner
bines76946792bines
binge85125512binge
bingo86020092bingo
binit76431582binit
bins66548252bin_s
bint67355042bin_t
bints76130182bints
birl65830472bi_rl
bizonal1845562bizonal
boral75831702boral
bridal9511452bridal
bubal94218212bubal
buna64730722buna_
bunas75126572bunas
canal75428042canal
clinal8311552clinal
dial55935062di_al
dinar66319892dinar
finale94116762finale
finals94316162finals
finial92814182finial
gingal81010152gingal
jingal1498592jingal
kina85631992kina_
kinas95626912kinas
lienal63912782lienal
linac7315412linac
lineal65616022lineal
mina65136912mina_
minae75627722minae
minas75434112minas
nidal65217102nidal
nival84915772nival
penal75228372penal
pial65636702pi_al
pibal95217322pibal
pical95524372pical
pina65842632pina_
pinas75434452pinas
pineal84817682pineal
pinnal84814272pinnal
pipal95118352pipal
renal55929502renal
rhinal9510192rhinal
rial45938092ri_al
rival85216502rival
riyal84413432riyal
sial45938832si_al
signal73711482signal
sisal54217732sisal
spinal84915312spinal
tical76021492tical
tidal64516442tidal
tincal83913362tincal
tineal66216162tineal
tonal53724302tonal
trinal6516962trinal
urinal6614122urinal
veinal93812962veinal
venal85523212venal
vial76731092vi_al
vina76331802vina_
vinals94716482vinals
vinas85126342vinas
vineal94814742vineal
vinyl115311622vinyl
viral86419592viral
vital84819672vital
zonal145116852zonal

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.0802233637.5
2DLD Change Limit53800981.65332546.9
3Display Results98980.0332969.7
 (SQL Overall)178691981.766101184.0
 
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.