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

89 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
overcrop154577(None) 
overcrops1646541overcrops
overcook1786152overcook
overcool1376782overcool
overcoy1536632overc_oy
overcram1537072overcram
overcrowd1844582overcrowd
overgrow1544832overgrow
overtop1237722over_top
intercrop1345763intercrop
outcrop1146773o_utcrop
overarch1647243overarch
overarm12239793overar_m
overarms13258383overarms
overblow1645033overblow
overbook1796323overbook
overbore131111583overbore
overborn13128703overborn
overbred1459843overbred
overbroad1545433overbroad
overcall1337673overcall
overcame151310693overcame
overcast132411973overcast
overcheap1953513overcheap
overclose1447013overclose
overcloud1544743overcloud
overcoat13312103overcoat
overcold14208483overcold
overcolor14134803overcolor
overcome151110703overcome
overcooks1875763overcooks
overcools1476773overcools
overcrams1646413overcrams
overcropped2143583overcropped
overcrowds1943093overcrowds
overcure132210053overcure
overcured15148643overcured
overcures14139993overcures
overcut12310423overc_ut
overcuts1337513overcuts
overdo10128363over_do_
overdog12106523over_dog
overdraw1535803overdraw
overdrew1536233overdrew
overdrove1646083overdrove
overdry1435903overdr_y
overflow1754923overflow
overfree1439003overfree
overgrew1535823overgrew
overgrown1644283overgrown
overgrows1645323overgrows
overheap16257343overheap
overhope1638343over_hope
overhot13411223over_hot
overjoy2034873over_joy
overlap12239833over_lap
overleap13237833overleap
overlook1596423overlook
overlord12119173overlord
overplot1338543overplot
overproof1745533overproof
overproud1545483overproud
overpump1743723overpump
overran10311663over_ran
overripe131410383over_ripe
overrode121810573over_rode
overrun1038023over_run
overscore1447863overscore
overshoe1438563overshoe
overshot1449433overshot
overslip1336323overslip
overslow1435693overslow
oversoon1138303oversoon
overstep1338033overstep
oversup1236043over_sup
overthrow1843363overthrow
overtip1238193over_tip
overtook15106053overtook
overtops1338513over_tops
overtrim1337473overtrim
overtrump1643563overtrump
overurge1277103overurge
overword15119223overword
overwore141111383overwore
overwork18118213overwork
overworn14118813overworn
overwrote1557693overwrote
velcro1144133_velcro_
velcros1244033_velcros

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.1701051123.5
2DLD Change Limit146162898.55017095.0
3Display Results89890.0461934.8
 (SQL Overall)178691898.76620384.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.