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

75 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
overdrove164608(None) 
overdrive1646751overdrive
overdone121210912overd_one
overdose121110062overd_ose
overdriven1744732overdriven
overdrives1746112overdrives
overlove14239172over_love
overrode121810572over_rode
overwrote1557692overwrote
outdrove1236473o_utdrove
overbore131111583over_bore
overborne14128023overborne
overbrake1847243overbrake
overbroad1545433overbroad
overbrowse1843933overbrowse
overclose1447013overclose
overcome151110703over_come
overcrop1545773overcro_p
overcrops1646543overcrops
overcrowd1844583overcrowd
overdare12311183overd_are
overdo10128363overd_o__
overdoer12128713overd_oer
overdoes121212543overd_oes
overdog12106523overd_o_g
overdogs13127493overd_ogs
overdosed14128073overd_osed
overdoses13119793overd_oses
overdraft1646713overdraft
overdrank1745123overdrank
overdraw1535803overdr_aw
overdrawn1644673overdrawn
overdraws1645663overdraws
overdress1346593overdress
overdrew1536233overdr_ew
overdried1439013overdried
overdries13310883overdries
overdrink1746273overdrink
overdrunk1743583overdrunk
overdry1435903overdr__y
overdue11138953overd__ue
overdye14126923overd__ye
overemote1447193overemote
overfree1439003overfr_ee
overgrade1457623overgrade
overgraze2276673overgraze
overgrow1544833overgro_w
overgrown1644283overgrown
overgrows1645323overgrows
overhope1638343over_hope
overlive142211293over_live
overloved16217643over_loved
overloves15218673over_loves
overprice16108893overprice
overprize23118683overprize
overproof1745533overproof
overproud1545483overproud
overrate11615683over_rate
override121512523over_ride
overrife14169933over_rife
overripe131410383over_ripe
overrude12168093over_rude
overrule11149673over_rule
oversave14310493over_save
overscore1447863overscore
overshoe1438563oversho_e
oversmoke1845013oversmoke
overstrode1445223overstrode
overtone111012573over_tone
overtrade1348503overtrade
overurge1277103overur_ge
overvote1438953over_vote
overwore141111383over_wore
overwrite1579083overwrite
redrove11249423_re_drove

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641756.45323034.4
3Display Results75750.0302500.0
 (SQL Overall)178691756.65626846.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.