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 “bilocation” 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
bilocation144612(None) 
bilocations1545291bilocations
allocation1248572allocation
bilection13156802bilec_tion
dislocation14147502dislocation
location102113912__location
mislocation15126412mislocation
relocation12312112relocation
advocation1645743advocation
allocations1347773allocations
allocution1244083allocution
avocation14168993_avocation
bifurcation1863373bifurcation
bijection20134793bijec_tion
bilections14136503bilec_tions
bisection13136983bisec_tion
bloviation1544003b_loviation
bolection13117673bolec_tion
ciliation111112493cil_iation
collocation1547173collocation
coloration12913183coloration
dilatation1147393dilatation
dilation92215463dil__ation
dislocations15136983dislocations
elocution1145673_elocution
evocation142010293_evocation
filiation121110243fil_iation
filtration1346433filtration
flotation1267813_flotation
illation8311943_il_lation
invocation1547543invocation
iodation9310383_i_odation
isolation9311643_isolation
lobation102110553__lobation
locations112512743__locations
locution10227663__locution
mislocations16145653mislocations
placation1339773_placation
plication13311683_plication
relocations13311143relocations
revocation15410813revocation
siltation939213sil_tation
sulcation11710733sul_cation
umbilication1884743umbilication
violation1238443vi_olation
vocation132311983__vocation

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 Filter1786911406030.423422437.4
2DLD Change Limit140603466.58021368.2
3Display Results46460.0133538.5
 (SQL Overall)178691467.01625469.1
 
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.