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

51 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
overclaim164533(None) 
overclaims1744681overclaims
overclaimed1944682overclaimed
overclass1436962overclass
overcram1537072overcra_m
overlaid122410382over_laid
overlain112112442over_lain
overplaid1546812overplaid
declaim1247363_de_claim
exclaim1844943__exclaim
overarm12239793over__arm
overcall1337673overc_all
overcalls1447203overcalls
overcame151310693overc_ame
overcast132411973overc_ast
overcivil1743253overcivil
overclaiming2045083overclaiming
overclean14115263overclean
overcleans15134883overcleans
overclear14134743overclear
overclears15134323overclears
overclose1447013overclose
overcloud1544743overcloud
overcoach1944793overcoach
overcoat13312103overcoa_t
overcoats1438853overcoats
overcrams1646413overcrams
overglad13116533overgla_d
overglaze2286273overglaze
overlade12611553over_lade
overland122312003over_land
overlap12239833over_la_p
overlaps13219523over_laps
overlate11716283over_late
overlax17238413over_la_x
overlay132410833over_la_y
overlays14239693over_lays
overlie102615013over_l_ie
overlit102714743over_l_it
overpaid14158933over_paid
overplaids1645433overplaids
overplan13258943overpla_n
overplans14249573overplans
overplant142510713overplant
overplay16257553overpla_y
overplays17287013overplays
overslip1336323oversl_ip
overtrain1259783overtrain
overtrim1337463over_trim
overwarm16236923over_warm
reclaim1137753_re_claim

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641518.70317079.3
3Display Results51510.0301700.0
 (SQL Overall)178691518.90620064.1
 
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.