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

100 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
hellos9532168(None) 
cellos84517801cellos
hallos95425101hallos
helios94816631helios
hello86522981hello_
helloes103717471helloes
hells85032041hell_s
helos84928061he_los
hillos94618891hillos
hollos95320631hollos
hullos94916291hullos
jellos134714281jellos
belles85325992belles
bellow114213352bellow
bellows124313302bellows
bells76432162bell_s
cello74919582cello_
cells75428062cell_s
dells66630942dell_s
duellos845762duellos
ells46431352_ell_s
fellas95116962fellas
felloe93513922felloe
felloes104114382felloes
fellow123712742fellow
fellows134212432fellows
fells85327382fell_s
fillos94415082fillos
hallo85127552hallo_
halloa94918122halloa
halloas104318462halloas
halloes104021522halloes
halloo95118972halloo
halloos103716742halloos
hallot95426782hallot
hallow124818322hallow
hallows134417392hallows
halls85633782hall_s
halos85230252h_alos
heals85733462heal_s
heels85625532heel_s
heils85222192heil_s
helio85321192helio_
hell75637892hell__
hellbox1944992hellbox
helled104024702helled
heller93322512heller
hellers103619832hellers
hellion10311132hellion
hellions11310022hellions
hellish13310722hellish
helloed113512432helloed
helms105619462he_lms
helo75332852he_lo_
helot85332682he_lot
helots95217702helots
helps105219342he_lps
helves124316062helves
herls85226432herl_s
heros84930862he_ros
hillo84721652hillo_
hilloa94713032hilloa
hilloas104413552hilloas
hilloes103815962hilloes
hills85431352hill_s
hollas94616902hollas
hollo84822162hollo_
holloa94914822holloa
holloas103814942holloas
holloes103818192holloes
holloo94415252holloo
holloos104013582holloos
hollow124212662hollow
hollows134412332hollows
hullo84417452hullo_
hulloa95011182hulloa
hulloas103911912hulloas
hulloes104113922hulloes
hulloo94511732hulloo
hulloos104010072hulloos
hulls84923562hull_s
jello126716272jello_
jells125522162jell_s
mellow114112222mellow
mellows123812232mellows
mells75031332mell_s
niellos736142niellos
peplos101211542peplos
phyllos1535582phyllos
selles64426982selles
sells55134432sell_s
shells94319522shell_s
telcos8710682telcos
tells55828942tell_s
tellys9348842tellys
telos55424522te_los
wells85426192well_s
yellow12429882yellow
yellows13329602yellows
yells85821942yell_s

Search took 3 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 Filter178691825510.330541487.9
2DLD Change Limit825511002.34335233.0
3Display Results1001000.0303333.3
 (SQL Overall)1786911002.70366108.4
 
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.