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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
biblists123687(None) 
biblist11310831biblist_
bibless11439172bibles_s
biblicists1653302biblicists
dialists9411412dialists
libelists1146952libelists
midlists1137522midlists
titlists837292titlists
vibists1256482vib_ists
violists1137662violists
ableists1036543_ableists
aiblins9311473aibli_ns
airlifts1143633airlifts
arbalists1148483arbalists
baalisms1238033baalisms
babbitts1144023babbitts
babysits15143543babysits
backlists17117413backlists
ballasts1037933ballasts
ballista1045803ballista
baptists1236723baptists
bassists1037183bassists
bemists113410703b_emists
bialies93618413biali_es
bialis83617163biali__s
bibelots1295133bibelots
bibles104617643bibl__es
biblical1445923biblical
biblicism1743543biblicism
biblicisms1853353biblicisms
biblicist1544863biblicist
biblike1536893bibli_ke
bibliotic1544243bibliotic
bibliotics1653173bibliotics
bibliotist1453843bibliotist
bibliotists1552863bibliotists
bicyclists1952283bicyclists
bigamists1444523bigamists
bilbies114712343bilbi_es
bilious9310933bi_lious
billets94516153bi_llets
billies93923503billi_es
billings113412633billings
billions102211793billions
binits85716673bi_ni_ts
biologists1349433biologists
biolyses1345573biolyses
biolysis1345363biolysis
birlings11359613birlings
blasts85116773__blasts
bliss75616913__blis_s
braillists1263663braillists
bubalises1346323bubalises
bundists1145383bundists
cabalists1339153cabalists
cellists1038563cellists
cubists11359023cub_ists
cyclists1545713cyclists
delists84414173_delists
diabolists1354463diabolists
dialist8517763dialist_
diallists1056003diallists
diarists9410363diarists
dualists958243dualists
duelists966003duelists
enlists749393_enlists
epiblasts1343353epiblasts
fabulists1444723fabulists
fideists1245543fideists
finalists123010163finalists
giblets103210423gibl_ets
holists104413963_holists
ibises83610543_ib_ises
idylists1244123idylists
insists739083_insists
kabalists1546293kabalists
libelist10310823libelist_
lists56628693___lists
midlist10312513midlist_
niblicks1643763niblicks
niellists944793niellists
nihilists1244853nihilists
oblasts947293_oblasts
oboists937903_oboists
oculists1037133oculists
oralists8611803oralists
pianists1049013pianists
pietists1038323pietists
pollists10910823pollists
realists83014843realists
relists73817053_relists
ribless93410343ribles_s
riblets93412553ribl_ets
sciolists1147213sciolists
shitlists1245533shitlists
siblings11108123siblings
simplists13266503simplists
stylists11207023stylists
subsists1037993subsists
titlist7312923titlist_
tribalists1286933tribalists
tubaists1055103tubaists
tubists9288323tub_ists
vibist11610583vib_ist_
violist10312143violist_
vitalists1239223vitalists
waitlists1244603waitlists

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621077.76618820.8
3Display Results1071070.0432488.4
 (SQL Overall)1786911077.96522434.5
 
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.