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

125 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
practises134962(None) 
practices1557991practices
practise12310141practise_
practised1446101practised
pastises103616052p_astises
practice1438732practice_
practiced1655112practiced
practicer1544592practicer
practicers1663592practicers
praises94121112pra__ises
praxises1739062pra_xises
precises123218332prec_ises
proclises1339542proclises
rachises131412412_rachises
abatises10311013aba_tises
abattises1155083abattises
actives12311523__actives
anaclises1147863anaclises
baptises1238923_baptises
bractless1335543bractless
braises93818873bra__ises
brattices1345553brattices
cactuses1237933_cactuses
chastises1437703chastises
dramatises1356773dramatises
fracases1336993frac_ases
fractions1449103fractions
fractious1456143fractious
fractures14147253fractures
fraises104215693fra__ises
franchises1855633franchises
fructoses1444253fructoses
glacises1138513glac_ises
graciles112511613grac_iles
iritises839983ir_itises
lactases1038523_lactases
lactoses1039833_lactoses
mantises10317923_mantises
orchises1338773or_chises
pachisis15268823p_achisis
pactions122613503p_actions
panties94230933p_anti_es
pantiles103617163p_antiles
paradises122513213paradises
parasitises1377383parasitises
parchisis16318573parchisis
parcloses1347963parcloses
parises94827193p_a_rises
parities10522983pariti_es
parties93230873p_arti_es
parvises133911923p_arvises
pasties94529813p_asti_es
pastimes123611903p_astimes
patines95225773p_a_tines
patsies93919483p_a_tsies
patties93425143p_atti_es
pavises125315493p_a_vises
peacetimes1643873peacetimes
pectases122411193p_ectases
pectines121914683p_ectines
pectizes21229793p_ectizes
piracies12312643pirac_i_es
platies93722543pla_ti_es
playtimes1644413playtimes
poetises10313953p_oetises
practic13312253practi__c
practical1548843practical
practicals1645543practicals
practicum17133773practicum
practicums18132753practicums
practising1586363practising
praecipes1544853praecipes
prairies10411463prairi_es
praise84419413pra__ise_
praised104214813pra__ised
praiser93413943pra__iser
praisers103410843pra__isers
pralines102217733pra_lines
prases84429023pra___ses
prates84633163pra_t__es
pratiques20114223pra_tiques
prattles10189413pra_ttles
preaccuses1644053preaccuses
precesses13310463precesses
precipes143212213prec_ipes
precise113518173prec_ise_
precised133213413prec_ised
preciser123411663prec_iser
precisest13259003prec_isest
precrisis1346453precrisis
premises123018273pr_emises
prentices131111903prentices
prestiges12310593prestiges
pretties10615133pretti_es
previses133814283pr_evises
prises84133173pr___ises
privatises15187403privatises
proactions1449343proactions
proactive1648363proactive_
procaines13311523procaines
processes13310233processes
proclisis1346773proclisis
proctitis1348373proctitis
proctitises15106323proctitises
promises122916763pr_omises
proptoses1349873proptoses
prosties101421193prosti_es
protases102115033pr_otases
protists10313363pr_otists
rachides141511223_rachides
racisms112310813_rac_isms
racists92613323_rac_ists
ragtimes1135823_ragtimes
raises64826543_ra__ises
ratines75328583_ra_tines
ratites74920683_ra_tites
rhachises1763973rhachises
rictuses1037563_rictuses
tractates1159763tractates
tractile10311073tractile_
tractions11511623tractions
tractive13310043tractive_
travoises1245863travoises
treatises9310373treatises
upraises10188473upra__ises

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.420425454.8
2DLD Change Limit1486411257.53319732.0
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.