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

121 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
halluces133561(None) 
alludes83610332_alludes
allures72913112_allures
almuces11316822_almuces
ballutes1037522ballutes
calluses1039322calluses
galluses936962galluses
halloes104021522hall_oes
hallucal1343482hallucal
phalluses1444262phalluses
thalluses1243902thalluses
abduces1286243_abduces
adduces1185763_adduces
allees64521483_all_ees
alleges84212573_alleges
alleles73812033_alleles
allies63827673_all_ies
allude73910903_allude_
alluded9327093_alluded
allure63012943_allure_
allured8299173_allured
allurer7348433_allurer
allurers8286773_allurers
almuce10348213_almuce_
almudes10418263_almudes
anlaces92313733_anlaces
balances1279973balances
ballades114211643ballades
ballies93725743ball_ies
ballute938543ballute_
bullaces12299433bullaces
calces104420053ca_l_ces
calices114321693ca_lices
callees94117783call_ees
calloses10313393calloses
callouses1147683callouses
callus85317073callu__s
callused1135853callused
calques182710193calqu_es
calyces14428803ca_lyces
cellules1036813cellules
chalices15310813cha_lices
challies133915643chall_ies
challises14358783challises
colludes11279223colludes
dalles74222063dall__es
dallies84023193dall_ies
failures1135163failures
falces115216003fa_l_ces
fallacies1446833fallacies
fauces114916153fa__uces
gallates92815533gallates
gallicas1136933gallicas
gallies84122713gall_ies
gallus74313203gallu__s
gallused1034193gallused
hachures1645873hachures
hales85449843ha_l__es
halflives1842783halflives
halides113416663ha_lides
halites103221193ha_lites
halituses1245573halituses
hallahs133912463hall_ahs
hallel93514093hall__el
hallels103310133hall_els
halloaed121510153halloaed
halloas104318463hall_oas
halloed113314913hall_oed
hallooed12168773hallooed
halloos103716743hall_oos
hallos95425103hall__os
hallowed15179493hallowed
hallower14139813hallower
hallowers15137723hallowers
hallows134417393hall_ows
halls85633783hall___s
hallux1637363hallu__x
hallways1745423hallways
haloes94623863ha_l_oes
halteres113414603halteres
halves124717093ha_l_ves
hances115621283ha__nces
haoles94919803haol__es
haplites1339993haplites
haploses1338853haploses
haulages1236623haulages
haylages1536013haylages
helices12313723h_elices
helloes103717463hell_oes
hillocks1736063hillocks
hilloes103815963hill_oes
hollies103420813holl_ies
holloes103818193holl_oes
hulloes104113923hull_oes
illudes8347553_illudes
illumes9327673_illumes
luces75528433___luces
malices114316623ma_lices
mallees93315973mall_ees
palaces114216463pa_laces
phallus1236063phallu__s
pollices12410753pollices
pollutes1037613pollutes
rallies73823343rall_ies
rallyes10348553rall_yes
sallies73227813sall_ies
salutes73716253sa_lutes
sauces84919503sa__uces
tallages92312003tallages
tallies73624603tall_ies
tallises82713263tallises
taluses7311213ta_luses
thallus1035603thallu__s
valances1398763valances
valences1388513valences
valguses1234233valguses
values94314943va_lu_es
valvules1443473valvules
walleyes1435603walleyes
wallies103320743wall_ies
walruses11554973walruses

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.436409841.7
2DLD Change Limit1461621217.39319770.3
3Display Results1211210.0432814.0
 (SQL Overall)1786911217.87222699.6
 
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.