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

95 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
gazelles1826656(None) 
gabelles11278931gabelles
gazelle17236331gazelle_
cadelles1139952cadelles
gabelle10259212gabelle_
gabelled12317582gabelled
gavelled13387362gavelled
gazeboes2043392gazeboes
gazettes18296862gazettes
nacelles1048392nacelles
abeles84719393_abe_les
alleles73812033_alleles
amarelles1145533amarelles
aneles64626293_ane_les
areoles71016953_areoles
azoles154614613_az_oles
bagatelles1352253bagatelles
belles85325993__belles
cadelle1039913cadelle_
canellas10310563canellas
dalles74222063da__lles
dazzles1636413daz_zles
duxelles1643963duxelles
echelles1346663echelles
failles102914123fa_illes
favellas1446163favellas
gabbles124415413ga_bbles
gables94222333ga__bles
gadflies1334733gadflies
gaggles103512593ga_ggles
gaieties9310183gaieties
galeres83514323gale_res
gales65442483ga___les
galettes93111153galettes
galilees936333galilees
galled84622853ga__lled
gallet73630853ga__llet
gallets83517403ga__llets
galley104215453ga__lley
galleys11369713ga__lleys
gallies84122713ga_llies
galls64729323ga__ll_s
gallus74313203ga__llus
gambles124016203ga_mbles
gamelans11115843gamelans
gametes10312253game_tes
garbles104016923ga_rbles
gargles94214893ga_rgles
gaselier946963gaselier
gaseliers1044923gaseliers
gateless9279953gateless
gaveled12399133gave_led
gavels105911093gave_l_s
gayeties1236883gayeties
gazaboes2043863gazaboes
gazebos1933493gaze_bos
gazers164516293gaze__rs
gazes155425913gaz___es
gazette17357363gazette_
gazetted19234853gazetted
gelees74116263g__elees
gelled84718893g__elled
girolles935523girolles
gravelled1475553gravelled
grilles83715023g_rilles
gruelled1034893gruelled
grueller935333grueller
gruellers1034183gruellers
guzzles16328043guz_zles
hazelhen2341623hazelhen
hazelhens2441563hazelhens
hazelly2254383hazell_y
hazels185710083haze_l_s
labelled11278293labelled
labeller10248073labeller
labellers11206553labellers
lamellas1098153lamellas
lapelled11227083lapelled
manilles102312593manilles
micelles1288833micelles
morelles10710493morelles
nacelle938153nacelle_
organelles1153473organelles
paellas9411413pa_ellas
panelled1138963panelled
patellas1039103patellas
pizzelles1942943pizzelles
ravelled12419783ravelled
raveller11339263raveller
ravellers12257163ravellers
razees154314763raze__es
roselles8310713roselles
selles64426983__selles
tailles72516463ta_illes
teazelled1943733teazelled

Search took 10 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 Limit146162959.03316180.9
3Display Results95950.0303166.7
 (SQL Overall)178691959.21919382.9
 
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.