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

99 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
sidecar104523(None) 
sidebar1045561sidebar
sidecars1145901sidecars
sidearm1035962side_arm
sidebars1146632sidebars
sideman1037972sideman
sideward1345942sideward
sideway1445672sideway
aider65431133aide__r
bider85728373bide__r
cider84723313cide__r
dear55343603__de_ar
debar85517863__debar
decaf114919443__decaf
decal85523233__decal
decare93919153__decare
decay114718483__decay
decor84717573__decor
denar65223293__denar
dewar95817733__dewar
eider64624743eide__r
endear74110013ende_ar
hider95024083hide__r
icecap1245223_icecap
idea59122773_ide_a_
ideal65716393_ide_al
ideas65919013_ide_as
ipecac1264623_ipecac
lidar6312723lid__ar
lifecare1364113lifecare
linear65113343line_ar
midcap1336473mid_cap
midyear1343343midyear
minicar11109313minicar
piecer105213083pi_ecer
redear73515173rede_ar
ricercar1263333ricercar
rider65231303ride__r
scar66434203s___car
scimetar1244043scimetar
sear47353843s__e_ar
secpar1037923s__ecpar
seder64826753sede__r
seducer1056503seducer
seneca839793seneca_
senecas939013senecas
sewar85421093s__ewar
shear85424833s_he_ar
shmear1176933shme_ar
siccan1037593si_ccan
siddur834573sid_dur
side55444483side___
sidearms1144093side_arms
sideband1245023sideband
sideboard1345173sideboard
sided74825953side__d
sidemen1037943sidemen
sidereal946053sidereal
sides65838363side__s
sidewalk1644093sidewalk
sidewall1244803sidewall
sidewards1445053sidewards
sideways1545233sideways
sidler74716963sid_ler
sierra637313si_erra
sieur5911893si_e_ur
siker95326033sike__r
silencer1036293silencer
silica8311243silica_
silicas9310603silicas
simar74920813si__mar
similar937853similar
simitar936733simitar
simular938673simular
sinecure1044323sinecure
sirdar7269103si_rdar
sitar54820543si__tar
siver85728613sive__r
sizar145214993si__zar
sizer145521813size__r
skiwear1442523skiwe_ar
slider73918363slide__r
slideway1543163slideway
smear74416393s_me_ar
snider74413913snide__r
soucar839323s_oucar
sowcar1135863s_owcar
spear75821063s_pe_ar
spider94516803spide__r
stelar64013863s_telar
supercar1249003supercar
swear85316853s_we_ar
tidemark1543393tidemark
tideway1445153tideway
timecard1343993timecard
vicar10513863vi__car
vinegar1134613vinegar
widener11318693widener
wider94826353wide__r

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.1701051123.5
2DLD Change Limit134027997.20318607.1
3Display Results99990.0462152.2
 (SQL Overall)178691997.41924085.6
 
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.