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 “pekin” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
pekin11151442(None) 
pein65834941pe_in
pekan111613971pekan
pekins121812231pekins
akin86328032_akin
begin85117352begin
deking125614552deking
eking106614982_eking
hemin103620932hemin
jerkin17258112jerkin
kin76353972__kin
levin84816412levin
pain65647242p_ain
patin76832852patin
pavin105623202pavin
peaking144317692peaking
pean66147172pe_an
pecan91919032pecan
pecking164017782pecking
pectin102615532pectin
peeing94618082peeing
peeking144414952peeking
peen65938082pe_en
peins76128062pe_ins
pekans121710552pekans
peke105926202pek_e
pekes114623562pekes
pekoe114612362pekoe
pelon74423212pelon
pen56558842pe__n
penis75129322penis
penni74617902penni
peon65635242pe_on
pepino10310332pepino
pepsin10310852pepsin
peri65636972peri_
peril75425952peril
peris75537072peris
perking143716462perking
petit74332652petit
pewit104622792pewit
piki106520562piki_
piking133719642piking
pikis115116392pikis
pin57066722p__in
pipkin14248602pipkin
plain74823302plain
poking133819302poking
pterin81014152pterin
puking133913062puking
punkin123611522punkin
purin75527592purin
pyin96823232p_yin
rein46040892re_in
renin54830032renin
repin75324702repin
resin54131052resin
rewin85623962rewin
serin55434442serin
skein94814412skein
skin85927532_skin
takin94921302takin
vein75625752ve_in
venin85118662venin
welkin1337312welkin
zein135620602ze_in

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800661.64332745.0
3Display Results66660.0135076.9
 (SQL Overall)178691661.96990752.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.