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

115 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
gallused103419(None) 
callused1135851callused
galluses936961galluses
alluded9327092_alluded
allured8299172_allured
calloused1244402calloused
calluses1039322calluses
galled84622852gall__ed
galleted1038212galleted
gallied94114992gall_ied
galloped12107142galloped
gallus74313202gallus__
abluted10188363_abluted
abused95614273_a_bused
accused12368423_accused
allayed11138063_allayed
alleged9389313_alleged
allied74217153_all_ied
allowed111610073_allowed
alloyed11158033_alloyed
allseed835953_allseed
allude73910903_allude_
alludes83610333_alludes
allure63012943_allure_
allurer7348433_allurer
allures72913113_allures
amused94412513_a_mused
aroused84914343_aroused
avulsed1133833_avulsed
ballasted1245453ballasted
balled94926893ball__ed
balloted1189043balloted
ballute938543ballute_
ballutes1037523ballutes
bloused104310643_bloused
called94126733call__ed
callose9313653callose_
calloses10313383calloses
callouses1147683callouses
callus85317073callus__
calqued19306523calqu_ed
campused1535253campused
caroused1149253caroused
caucused1344093caucused
caused95117043ca__used
colluded12296453colluded
dallied93713603dall_ied
deloused1036973deloused
fallowed15127753fallowed
gabled105518453gabl__ed
galeated104111573galeated
gallanted1145893gallanted
gallate83417123gallate_
gallates92815523gallates
galleried1146923galleried
gallet73630853gall__et
galley104215453gall__ey
galliard10125753galliard
gallies84122713gall_ies
gallooned1144463gallooned
galloper11137183galloper
gallous82813953gallous__
gallowses1374943gallowses
galls64729323gall_s__
galoped11138063ga_loped
galoshed1334473galoshed
gaoled84814493gaol__ed
gassed85217633ga__ssed
gauged94713473ga__uged
gaumed104610323ga__umed
gelled84718893gell__ed
gilled84521633gill__ed
gillied95512313gill_ied
glassed93710433g_lassed
glossed94410073g_lossed
glouted9429713g_louted
glued75118363g__lu_ed
groused94712833g_roused
gulled84521373gull__ed
gullied93812063gull_ied
halloaed121510153halloaed
halloed113314913hall_oed
hallooed12168773hallooed
hallowed15179493hallowed
halluces1335613halluces
illuded9305763_illuded
illumed10285863_illumed
jalousied1742033jalousied
lalled74218753lall__ed
loused74822913__loused
malled94626103mall__ed
malposed1344563malposed
palled94625163pall__ed
palleted1139863palleted
paused95114963pa__used
phalluses1444263phalluses
polluted1135433polluted
rallied83514083rall_ied
sallied83316953sall_ied
sallowed12149033sallowed
saluted84511703sa_luted
tallaged10257923tallaged
tallied83314753tall_ied
tallises82713263tallises
tallowed12157713tallowed
taluses7311213ta_luses
thalluses1243903thalluses
valguses1234233valguses
valleyed1534013valleyed
valued104011153va_lu_ed
walled104021293wall__ed
walleyed1534153walleyed
walloped14146833walloped
wallowed15148163wallowed
walruses11554973walruses

Search took 9 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.186960704.3
2DLD Change Limit1461621158.32617554.9
3Display Results1151150.0631825.4
 (SQL Overall)1786911158.57520838.6
 
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.