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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
russify133406(None) 
fussily13267602fussily
justify2034662justify
mussily12279772mussily
ossify1244972_ossify
russety1034612russety
rustily103112992rustily
basify1437513_basify
bossily1237563bossily
brassily1336623brassily
brutify1543883bru_tify
bushily15268893bushily
busily112211503bu_sily
bussing103614623bussing
classify1644693classify
crucify1744063cru_cify
crusily12199093cru_sily
crustily13328173crustily
cushily15257923cushily
cussing103814273cussing
densify1435293densify
dressily1246443dressily
dulcify1643023dulcify
duskily15236743duskily
dustily113211523dustily
emulsify1642703emulsify
falsify1643613falsify
fructify1942353fructify
fussier103610673fussier
fussing113611683fussing
fussy115613953fuss__y
fustily133111373fustily
gasify1336333_gasify
gassily1137813gassily
gossipy1343953gossipy
grassily1236433grassily
gushily14257823gushily
gussie72910153gussi_e
gussied9267193gussied
gussies82813303gussies
gussy95314323guss__y
gustily113010903gustily
gutsily11267223gutsily
huskily17236333huskily
hussies103213293hussies
hussy116812763huss__y
huswife1642223huswife
jussive1734293jussive
lustily103611243lustily
massif11412533massif_
massifs1237743massifs
messily12298813messily
mummify1643333mummify
mushily152410093mushily
muskily16289043muskily
mussier93314353mussier
mussing104015543mussing
mussy104117643muss__y
mustily123613633mustily
mystify1843563mystify
nullify1334713nullify
prissily1346693prissily
prussic1144743prussi_c
purify14399153pu_rify
pursily1238213pursily
pushily15247983pushily
pussier93711993pussier
pussies93615693pussies
pussley12375123pussley
pussly11407373puss_ly
pussy105614843puss__y
qualify2235473qualify
raisiny10319923raisiny
ramify14268753r_amify
rarify123210063r_arify
ratify122610043r_atify
rectify1536453rectify
reedify1465763reedify
reify114814973r__eify
rejustify2242083rejustify
resift94017723r_esift
resinify1445053resinify
resiny94617363r_esiny
reunify1344453reunify
riskily1436413riskily
rosily93914713r_osily
rosiny94414533r_osiny
ruddily1236303ruddily
rugosity1243733rugosity
rushier103411973rushier
rushing113817703rushing
rushy115414813ru_s_hy
rusine63916593ru_sine
russet6319433russ_et
russets738163russets
russified1344733russified
russifies1245443russifies
russifying1743923russifying
rustic8712673rusti_c
rusticly1345183rusticly
rustics9810733rustics
rustier74416363rustier
rusting83821263rusting
rusty85221053ru_s_ty
ruttily10338613ruttily
salsify1334703salsify
sassily1038723sassily
subsidy1345973subsidy
sussing84013703sussing
testify13246943testify
trussing9268653trussing
trustily11257103trustily
tussis6379953tussi_s
tussive1035303tussive
uglify1333913_uglify
unify113611113_u_nify
versify1636333versify
wussier10408083wussier
wussies103411083wussies
wussy115810343wuss__y
yuppify2042163yuppify

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271218.45315855.6
3Display Results1211210.0462630.4
 (SQL Overall)1786911218.65520646.0
 
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.