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

45 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
inearthed134362(None) 
unearthed1345571unearthed
earthed1139922__earthed
inarched1486112in_arched
inearth1037042inearth__
inearths1144932inearth_s
aneared8512743anear__ed
berthed13259123_be_rthed
breathed14469643brea_thed
earthen1039253__earthen
hearted113314023_heart_ed
ideated9310973idea_t_ed
imparted13248063impart_ed
inarches1358043in_arches
inarmed10268673in_ar_med
inbreathed1642783inbrea_thed
incanted11259543incant_ed
inearthing1443543inearthing
inedited10278993inedit_ed
infarcted1544243infarcted
ingather1244783inga_ther
inserted92413053insert_ed
insheathed17173073inshea_thed
inswathed1642963inswathed
interarched1744493interarched
intorted9310123intort_ed
inverted122312163invert_ed
iterated91213823iterat_ed
linearised1143933linearised
linearized2044583linearized
lineated9711063linea_t_ed
narthex1734263_n_arthex
neared75119803_near__ed
neatherd12107193_nea_therd
searched14209253_searched
sheathed1547223shea_thed
unarched14128553un_arched
unbathed1437223unba_thed
uncarted11312053uncart_ed
unearned9310063unear_ned
unearth1037063unearth__
unearthly1543153unearthly
unearths1144353unearth_s
unparted11310823unpart_ed
wreathed15257463wrea_thed

Search took 9 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.420425454.8
2DLD Change Limit148641457.98618612.7
3Display Results45450.0162812.5
 (SQL Overall)178691458.42221217.2
 
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.