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

73 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
changeling174567(None) 
changelings1843181changelings
channeling1645201channeling
angeling102811732__angeling
cageling12310842c_a_geling
canceling14310162c_anceling
chandelling1844452chandelling
changing153211512chang__ing
channelling1743992channelling
hanseling1338062_hanseling
aneling82719503__an_eling
angering102113803__angering
angling92816043__ang_ling
cagelings1335413c_a_gelings
canaling112016413c_an_aling
canalling1239553c_analling
cancelling1547213c_ancelling
candling122313873c_an_dling
cankering162110793c_ankering
canoeing11310213c_anoe_ing
cantering122417373c_antering
chaffering22104643chaffering
chambering20116043chambering
chamfering21125333chamfering
chancing162810283chan__cing
chandelier1654293chandelier
changeless1643873changeless
channelize2453263channelize
channelizing2752853channelizing
chanting143413533chan__ting
chaptering18107963chaptering
charging152910773charg__ing
chartering16109253chartering
chasseing1554963chasse_ing
chastening1656523chastening
chattering16108643chattering
chiseling1536403ch_iseling
chuntering1647803chuntering
clanging124012123clang__ing
clangoring1443913clangoring
coannexing2083163coannexing
congealing1447633c_ongealing
congeeing1337903c_ongeeing
counseling1345463counseling
crankling16147293cran_kling
creneling1247733cren_eling
cudgeling1443663c_udgeling
dangering12239303_dangering
dangling112611233_dang_ling
flanneling1443813flanneling
gangling112411403_gang_ling
haggling14227273_ha_ggling
handling132312713_han_dling
handseling1544323_handseling
hangaring1438033_hangaring
hanging123518703_hang__ing
hankering17239383_hankering
hanselling1445623_hanselling
hungering14187683_hungering
jangling17249623_jang_ling
mangling122312623_mang_ling
paneling111013623_pan_eling
rechanneling1852453rechanneling
shaveling1646843sha_veling
shingling14136973shing_ling
spanceling1543943spanceling
spangling1336373spang_ling
tangling101712543_tang_ling
twangling1434453twang_ling
wangling132310993_wang_ling
whanging16267143whang__ing
whingeing1733533whinge_ing
wrangling1456223wrang_ling

Search took 7 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.420425454.8
2DLD Change Limit140603735.62624991.6
3Display Results73730.0461587.0
 (SQL Overall)178691736.09229332.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.