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

63 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
tangerine104840(None) 
tangerines1147541tangerines
algerine9810282_algerine
angering102113802_angering
anserine8313092_anserine
dangering12239302dangering
algerines1069083_algerines
angeling102811733_angeling
anguine839913_ang_uine
ankerite1248923_ankerite
anserines9411293_anserines
badgering1436963badgering
bannering12208803bannering
bantering122414233bantering
cankering162110793cankering
cantering122417373cantering
daggering13246113daggering
dandering122511063dandering
fingering1439193fingering
gandering122111293gandering
gangrene1044363gang_rene
gingering1238873gingering
hangaring1438033hangaring
hankering17239383hankering
hungering14187683hungering
laagering1136833laagering
lagering102212313la_gering
lingerie959203lingeri_e
lingering11310513lingering
margarine1247713margarine
mongering13310353mongering
orangerie10105483orangeri_e
pandering133211963pandering
pangene102711963pange__ne
passerine1147083passerine
saggering12197793saggering
sanguine947633sang_uine
staggering13194583staggering
strangering1345183strangering
tabering112211423ta_bering
taborine102510683ta_borine
tacrine9311293ta__crine
tagline82412453ta_g_line
tampering1438453tampering
tangence1146703tange_nce
tangent8314993tange__nt
tanging93419523tang__ing
tangling101712543tang_ling
tangoing10177893tang_oing
tangolike1453843tangolike
tanneries9310423tanneries
tapeline10310363ta_peline
tapering112112503ta_pering
targeting1137303targeting
tattering102212323tattering
taurine7311363ta__urine
tendering112210813tendering
tenderize1976183tenderize
tentering102313203tentering
tingeing10198553tinge_ing
tinkering1437703tinkering
wagering13219523wa_gering
wandering143310983wandering

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 Filter1786911486410.423422437.4
2DLD Change Limit148641636.34323433.9
3Display Results63630.0163937.5
 (SQL Overall)178691636.78226347.8
 
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.