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

87 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
cockpit174799(None) 
cockpits1845741cockpits
coalpit1148512coalpit
crockpot1844292crockpot
backbit17129103backbit
backfit18108213backfit
backlit15911903backlit
cesspit1145463cesspit
coadmit1247833coadmit
coalpits1245403coalpits
coapt96131533co_ap_t
cocain101315013coc_ain
cocci82812673coc_ci_
coccic8298943coc_cic
coccid102910743coc_cid
coccoid11299283coccoid
cochair1446313cochair
cochin131313203coc_hin
cock126332903cock___
cockade1638133cockade
cockapoo1893823cockapoo
cockbill1844943cockbill
cockboat1857393cockboat
cocked155022563cock_ed
cocker144320393cock_er
cockers153618333cockers
cockeye1867223cockeye
cockfight2452633cockfight
cockier154013623cockier
cockiest163013293cockiest
cockily1838493cockily
cocking163619983cocking
cockish1838503cockish
cockle143913573cock_le
cockled163710823cockled
cockles153414643cockles
cocklike1536733cocklike
cockling172310393cockling
cockloft1945693cockloft
cockney1835873cockney
cocks135227163cock__s
cockshut1944433cockshut
cockshy2143223cockshy
cockspur1842603cockspur
cocktail1645363cocktail
cockup1635713cock_up
cockups1735223cockups
cocky164215933cock__y
cocomat13413623cocomat
coconut11511473coconut
coedit9316243co_edit
coempt12311033coemp_t
cohabit1449563cohabit
comfit133112423co_mfit
commit124016703co_mmit
compt116328223co_mp_t
conceit113218073conceit
concept133314443concep_t
concepti14328273concepti
conduit10713083conduit
confit113316403co_nfit
cookie123716043cook_ie
cookout13410153cookout
coopt95929853co_op_t
coscript1456633coscript
cowpat13312033co_wpat
cowpie133511513co_wpie
crackpot1843833crackpot
crampit1338863crampit
crocket154615673crock_et
crockpots1943023crockpots
docket134721173dock_et
duckpin1643463duckpin
incipit1158923incipit
jackpot2245013jackpot
lickspit1643913lickspit
locket123922473lock_et
locknut1345253locknut
lockout1359333lockout
lockset13311163lockset
occipita1452583occipita
occiput1344763occiput
pocket144622623pock_et
porkpie1544673porkpie
rocket125425283rock_et
socket123923523sock_et
stockpot1644663stockpot

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.420425454.8
2DLD Change Limit134027877.06318975.9
3Display Results87870.0332636.4
 (SQL Overall)178691877.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.