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

63 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
externalised205412(None) 
externalise1856081externalise_
externalises1955461externalises
externalized2955191externalized
eternalized21117332e_ternalized
externalism2055932externalis_m
externalisms2154952externalisms
externalize2756382externalize_
externalizes2855812externalizes
internalised13127042internalised
eternalize19118503e_ternalize_
eternalizes20118173e_ternalizes
eternised10116273e_tern__ised
exteriorised2053193exteriorised
externalising2153393externalising
externalities2055183externalities
externality2155043externali_ty
externals1666623external_s__
internalise111510553internalise_
internalises12149113internalises
internalized22147453internalized
materialised1555473materialised
centralised1446604cent_r_alised
entertained1245174enterta_ined
eternalness1153824e_ternalness
eternals8238954e_ternal_s__
eternise8119664e_tern__ise_
eternises9119454e_tern__ises
eternized19116604e_tern__ized
etherealized2553354etherealized
exercised1944634ex_er__cised
extemporised24163064extemporised
exteriorise1854634exteriorise_
exteriorises1954214exteriorises
exteriorized2953194exteriorized
extermined2045324exter__mined
external1577224external____
externalizing3054614externalizing
externally2045544external__ly
extradited1944414ext_r_adited
generalised13185684gener_alised
internalize20149594internalize_
internalizes21138694internalizes
lateralized2147404later_alized
liberalised1445204liber_alised
literalized2147074liter_alized
materialise1347834materialise_
materialises1447324materialises
materialized2446554materialized
mineralised1445754miner_alised
nationalised13197814nationalised
naturalised1254754natur_alised
neutralised12115374neut_r_alised
paternalism1556774paternalis_m
paternalisms1656084paternalisms
paternalist1358594paternalis_t
paternalists1456164paternalists
penalised12108834__pe_nalised
rationalised13237724rationalised
serialised1188284__serialised
sterilised1145444_ster_ilised
vernalized2348424__vernalized
westernised1552914western__ised

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 Filter1786911247900.393454684.5
2DLD Change Limit124790637.67016269.9
3Display Results63630.0331909.1
 (SQL Overall)178691638.09622071.5
 
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.