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

56 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
foreskins164704(None) 
foreskin1547021foreskin_
doeskins1344902do_eskins
foresails1247152foresails
foresting13311362foresting
foxskins2242882fo_xskins
moleskins1544242moleskins
capeskins1744073capeskins
coonskins1544183coonskins
cowskins1745263co_wskins
deerskins1443203deerskins
doeskin1245153do_eskin_
fireships1746023fireships
firkins1437663fir__kins
forebrains1544623forebrains
foredoing1456483foredoing
foregoing1455793foregoing
forenoons1245743forenoons
forensics1443833forensics
foreruns1146623fore_runs
foresaid1247803foresai_d
foresail1147823foresai_l
foreseeing1444553foreseeing
foreseen1139103foreseen_
foreseers1237403foreseers
foresees11311643fores_ees
foreshank1944673foreshank
foreshanks2043833foreshanks
foreshows1875973foreshows
foreside12310303fores_ide
foresides1339703foresides
forestays1546623forestays
foresters12312533foresters
forestial1247233forestial
forestries1348553forestries
forests104114953fores__ts
foretokens1742833foretokens
forewarns1585633forewarns
forewing1539003fore_wing
forewings1645113fore_wings
forking154014843for__king
formalins1447213formalins
forsaking1745173forsaking
foxskin2143133fo_xskin_
freaking163611453f_reaking
freshens14298313f_reshens
freshing152611023f_reshing
frisking16268363f_risking
goatskins1442633goatskins
griskins1335953_griskins
moleskin1444083moleskin_
oilskins1243873_oilskins
redskins1385873__redskins
resins64528773__res_ins
wineskins1644213wineskins
woolskins1643003woolskins

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 Filter1786911486410.420425454.8
2DLD Change Limit148641567.37620152.0
3Display Results56560.0163500.0
 (SQL Overall)178691567.81222873.9
 
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.