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

71 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
sidearms114409(None) 
sidearm1035961sidearm_
firearms1335402firearms
sidebars1146632sidebar_s
sidecars1145902sidecar_s
sidewards1445052sidewards
aiders74524633aide_r_s
biders94822803bide_r_s
birdfarms1741853birdfarms
ciders94620083cide_r_s
dears65736883__dear_s
derms85022893__de_rms
disarms1039043di_sarms
eiders74321363eide_r_s
endears83710053endear_s
epiderms1345043epide_rms
fideisms1444453fideisms
firearm1237193firearm_
forearms1336603forearms
hiders104919653hide_r_s
ideals75012503_idea_ls
ideas65919013_idea__s
ideates8313723_ideates
inarms8410093_i_narms
lidars7310783lid_ar_s
midterms13284853midterms
midyears1443403midyear_s
prearms11369173_prearms
rearms85114653__rearms
redears82814453redear_s
riders74123903ride_r_s
screams114810613screa_ms
seams75731663s__ea_ms
sears54744913s__ear_s
seders74420283sede_r_s
shears93820903s_hear_s
shmears1277073shmear_s
siddurs934173siddur_s
sidebands1344443sidebands
sidebar1045563sidebar__
sideboards1444633sideboards
sideburns1242093sideburns
sidecar1045233sidecar__
sidedress1143683sidedress
sides65838363side___s
sidewalks1743533sidewalks
sidewalls1344283sidewalls
sideward1345943sidewar_d
sideways1545233sideways
sidlers83414223sidler_s
sierras737863si_erras
sieurs659043si_eur_s
simars84916933si_mar_s
sirdars8228213sirdar_s
sitars65417593si_tar_s
sivers95324153sive_r_s
sizars154812623si_zar_s
sizers155215813size_r_s
sliders83515223slide_r_s
smarms105712533s__marms
smears84714433s_mear_s
spears84019473s_pear_s
sperms102512603s_pe_rms
spiders103914413spide_r_s
steams84916903s_tea_ms
streams94713373strea_ms
swarms116112163s__warms
swears94114073s_wear_s
tidemarks1643063tidemarks
tonearms1044713tonearms
underarms1246733underarms

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162718.28317646.0
3Display Results71710.0135461.5
 (SQL Overall)178691718.45221141.9
 
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.