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 “repairabilities” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

65 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
repairabilities195536(None) 
replicabilities2155102replicabilities
separabilities1847342sepa_rabilities
bearabilities1748673be_a_rabilities
desirabilities1747523de_sirabilities
readabilities1649303re_a_dabilities
recallabilities1963953recallabilities
reliabilities15410443re_li_abilities
repairability2055833repairabilit__y
repeatabilities1955913repeatabilities
reputabilities1847423rep_utabilities
wearabilities1848413we_a_rabilities
admirabilities1956024_admirabilities
applicabilities2353734applicabilities
arabilities13413094___a_rabilities
attainabilities1753754attainabilities
availabilities1955744_availabilities
breathabilities2253994bre_athabilities
comparabilities2374374compa_rabilities
creditabilities2065274cre_ditabilities
decidabilities2046234de_cidabilities
deniabilities1649764de_ni_abilities
dependabilities2155244dependabilities
detachabilities2354144detachabilities
deterrabilities1875384deterrabilities
equitabilities2566014_equitabilities
erasabilities1549604_era_sabilities
excitabilities2556314_excitabilities
expandabilities2763874expandabilities
germinabilities2084504germinabilities
heritabilities1958194he_ritabilities
impalpabilities2363954impalpabilities
impassabilities21155244impassabilities
invariabilities2055124invariabilities
leachabilities2155534le_achabilities
mailabilities1767694__mailabilities
measurabilities1964224measurabilities
memorabilities20137004me_morabilities
mensurabilities1964414mensurabilities
metastabilities1955494metastabilities
obtainabilities1963404obtainabilities
operabilities17510054_op_erabilities
packabilities2346554__packabilities
palpabilities1947244__palpabilities
penetrabilities1965324penetrabilities
perdurabilities2074434perdurabilities
pliabilities1649384__pli_abilities
preferabilities2254604pre_ferabilities
reasonabilities1754664reasonabilities
reeligibilities1862974reeligibilities
reformabilities2264534reformabilities
refundabilities2153924refundabilities
remediabilities2054614remediabilities
removabilities2186314re_movabilities
renewabilities1956204re_newabilities
rentabilities15411234re__ntabilities
resectabilities1956014resectabilities
reusabilities1549264re__usabilities
roadabilities1647794r_oa_dabilities
severabilities1947434se_verabilities
stainabilities1655724_stainabilities
trainabilities1646594_trainabilities
treatabilities1657604tre_a_tabilities
variabilities1848634__variabilities
venerabilities1967354ve_nerabilities

Search took 3 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 Filter178691435480.0802233637.5
2DLD Change Limit43548651.98321960.7
3Display Results65650.0461413.0
 (SQL Overall)178691652.10984727.8
 
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.