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

82 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
abandon104546(None) 
abandons1145351abandons
abandoned1342722abandoned
abandoner1242692abandoner
bandog1038722_bandog
abalone938893aba_lone
abandoners1342473abandoners
abandoning1472583abandoning
abator84512713aba_tor
ablation10312433ablation
aboon74918703ab__oon
abrasion1046623abrasion
abundant1145453abundant
aland65526413aland__
alands75418373aland_s
alanin6317273alan_in
alation72920553alation
alencon945733alencon
amadou977593ama_dou
amandine1148553amandine
amazon1736823ama_zon
amnion84812053a_mnion
ancon75718233__ancon
anion55028813__anion
anon46134853__an_on
anyon85615223__anyon
baboon103613913_baboon
bacon95620593_ba_con
ballon84117493_ballon
banco94019393_banco_
bancos104713893_bancos
band76740903_band__
banda85223103_band_a
bandana10179463_bandana
bandas95120543_bandas
bandbox1943763_bandbox
banded105223173_banded
bander93928223_bander
banding114921413_banding
bandit93821133_bandit
bandogs1138363_bandogs
bandora1038813_bandora
bandore10611633_bandore
bands85233423_band_s
bandy114824183_band_y
banian8315383_banian
banjo143812443_banjo_
banjos15378893_banjos
banyan1139483_banyan
baron78131243_ba_ron
baryon111211613_baryon
basion84315853_basion
baton75822423_ba_ton
bonbon10310073_bonbon
bunion83111313_bunion
calando1037383calando_
candor94516423_candor
cannon84514443_cannon
canon74725303_can_on
canton85722993_canton
canyon114512033_canyon
carbanion1345943carbanion
cardon94120853_cardon
chanson1238043chanson
fandom122110893_fandom
fanion94514323_fanion
fanon84619013_fan_on
grandson1055413grandson
hagdon1188283_hagdon
lardon74415063_lardon
nandin7313033_nandin
pagandom1443533pagandom
pardon94618733_pardon
quandong1942943quandong
radon64620503_ra_don
randan7315253_randan
random92513553_random
sabaton937713saba_ton
sabayon1244233saba_yon
tendon7312033_tendon
wanion93213063_wanion
wanton94413813_wanton

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027827.36018210.2
3Display Results82820.0165125.0
 (SQL Overall)178691827.53223724.2
 
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.