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

46 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
algebra104304(None) 
algebras1143221algebras
algebraic1481742algebraic
palpebra1442682palpebra
agenda837253a_genda
ager55935843a_ge_r_
agers65027853a_ge_rs
agger76420893agge_r_
aggers85817793agge_rs
agora6914333a_g_ora
alba68328333al__b_a
alder65421913alde_r_
alders74218423alde_rs
alegar739283alegar_
alegars838933alegars
alert54740653al_e_rt
alexia132910463al_exia
alga57927603alg___a
algebraist1382313algebraist
algor6513053alg_or_
algors7312553alg_ors
allegro844853allegro
allobar946663allobar
almemar1144303almemar
alter54828503alte_r_
alters64924223alte_rs
ameba9312383a_meb_a
amoeba1035603amoeb_a
anger66225873ange_r_
angers75222543ange_rs
angora71111573ang_ora
auger64922473auge_r_
augers73818703auge_rs
caldera1037963calde_ra
cerebra1155923cerebra
gleba83910243gl_eb_a
labra75415463_l_abra
lager65132863lage_r_
lagers74826143lage_rs
libra74712423_l_ibra
palabra1137183pal_abra
palpebrae1542513palpebrae
palpebral1542213palpebral
palpebras1542643palpebras
pleura837533pl_eura
zebra1637883__zebra

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 Filter1786911340270.406440125.6
2DLD Change Limit134027466.53020524.8
3Display Results46460.0162875.0
 (SQL Overall)178691466.95225703.5
 
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.