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

61 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
cooktop154404(None) 
cooktops1644061cooktops
cookshop1943772cookshop
rooftop12133252rooftop
bookoo1248343book_oo
bookoos1337503bookoos
bookshop1943423bookshop
cartop104213563c_artop
coactor1139123coactor
cockatoo16105783cockatoo
cockup1635713cock_up
cogito939203cogito_
cogitos1037613cogitos
collop107312313c_ollop
conto76027173c_onto_
contos84923233c_ontos
coocoo1069693coo_coo
cook107236933cook___
cookbook1544443cookbook
cooked135921363cook_ed
cooker124722453cook_er
cookers134619463cookers
cookery164210393cookery
cookey155414333cook_ey
cookeys16478503cookeys
cookie123716043cook_ie
cookies133719273cookies
cooking143818973cooking
cookoff1954073cookoff
cookout13410153cookout
cooks115429143cook__s
cookshops2043773cookshops
cookstove1842873cookstove
cooky145321363cook__y
coolth1139513coolt_h
coolths1236013coolths
coontie9311423coontie
coop87238653c_o__op
coopt95929853coopt__
coopted123710763coopted
cooption1288343cooption
coopts105814583coopt_s
coot67860383coo_t__
cooter85128613coo_ter
cootie84223093coo_tie
coots75636843coo_t_s
cotton8312993c_otton
cowflop1742893cowflop
cowplop1643363cowplop
croton84415453cro_ton
crouton947133crouton
desktop1442413desktop
doorstop1143113doorstop
doowop1283853doo_wop
foretop12117893foretop
hookup1534423hook_up
lookup1233453look_up
nonstop9106923nonstop
postop10511943_postop
rolltop944043rolltop
rooftops13152913rooftops

Search took 7 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.1401276364.3
2DLD Change Limit134027616.67320085.0
3Display Results61610.0134692.3
 (SQL Overall)178691616.82626178.0
 
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.