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

54 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
crabwise154361(None) 
crablike1636022crablike
arabize1849343arab_ize
barbwire1543863barbwire
braise84318753bra__ise
cabbie122913353c_abbi_e
cabbies133115163c_abbies
caboose1138273c_aboose
camise103319633c_a_mise
carabine12412393carab_ine
carbide126112493carb_ide
carbine112918643carb_ine
carburise1345813carburise
chablis14368563chablis_
chaise114916413cha__ise
chamise143612853cha_mise
chastise1348173chastise
coastwise1463023coastwise
crabbier14326803crabbier
crabbiest1535623crabbiest
crabbily1744343crabbily
crabbing15287933crabbing
crabs95421393crab__s_
cramoisie1343393cramoisie
cramoisy1543703cramoisy
crankish1736513crankish
crannies10313013crannies
crappie13298983crappi_e
crappies142911153crappies
crasis85020473cra_sis_
crawfish1944233crawfish
crawls114712083cra_wls_
craws105723123cra_w_s_
crayfish1944253crayfish
crazies183413853cra_zies
creolise1037863creolise
crosswise1443343crosswise
cruise84314043cr__uise
fanwise1336633_fanwise
flatwise1443973flatwise
fraise94214913fra__ise
framboise1642733framboise
manwise1239183_manwise
practise12310143practise
praise84419413pra__ise
rabbies113416053_rabbies
rabbis102613163_rabbis_
rabies85226023_rab_ies
raise54828053_ra__ise
rawish123012913_ra_wish
taxwise1734253_taxwise
travoise1145603travoise
urbanise10107283urbanise
warpwise1642853warpwise

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit146162548.22017781.3
3Display Results54540.0461173.9
 (SQL Overall)178691548.70220534.5
 
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.