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

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

117 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
isolationists138465(None) 
isolationisms1563741isolationisms
isolationist1255881isolationist_
inflationists1653842inflationists
isolationism1453942isolationis_m
abolitionists15134223abolitionists
evolutionists16145713evolutionists
inflationisms1862953inflationisms
inflationist1555293inflationist_
isolations10310693isolation___s
salvationists1653563_salvationists
abolitionisms17153844abolitionisms
abolitionist14145134abolitionist_
abortionists1454974abo_rtionists
adoptionists1553924ado_ptionists
associationists17183074associationists
coalitionists1583944coalitionists
creationists1476624_creationists
demolitionists1763474demolitionists
deviationists17104744deviationists
devolutionists18144414devolutionists
educationists1654344educationists
elocutionists1554314elocutionists
evolutionisms18124644evolutionisms
evolutionist15126814evolutionist_
illusionists1253674i_llusionists
inflationism1753474inflationis_m
insolations1149184insolation___s
intuitionists1363894intuitionists
isolation9311644isolation____
liberationists16143694liberationists
operationists1556054operationists
revolutionists17145124revolutionists
salvationisms1873004_salvationisms
salvationist1554404_salvationist_
selectionists1556014_selectionists
solations9814624_solation___s
vacationists1754584_vacationists
abolitionism16134145abolitionis_m
abortionist1356165abo_rtionist_
abstractionists19143305abstractionists
adoptionisms1753355ado_ptionisms
adoptionist1454965ado_ptionist_
annexationists21192575annexationists
associationisms19192345associationisms
associationist16173355associationist_
coalitionist1485505coalitionist_
colonists112512505_col___onists
cooperationists1963195cooperationists
creationisms1685525_creationisms
creationist1379235_creationist_
demolitionist1654515demolitionist_
desolations12310595desolation___s
deviationisms1953885deviationisms
deviationist1656155deviationist_
devolutionist17135155devolutionist_
disunionists1352875dis__unionists
educationist1555265educationist_
elocutionist1455095elocutionist_
evolutionism17105125evolutionis_m
exclusionists2263335exclusionists
extortionists2074385extortionists
fictionists1655995__fictionists
illations9311395i_llation___s
illuminists1353465i_llumi_nists
illusionisms1452925i_llusionisms
illusionist1154935i_llusionist_
immolations1545465immolation___s
inflations13310325inflation___s
insolation10410215insolation____
insulations11310235insulation___s
integrationists1682575integrationists
intuitionisms1563315intuitionisms
intuitionist1264995intuitionist_
iodations1039115i_odation___s
irrationalists1464735i_rrationalists
irreligionists1571765irreligionists
isochronisms1962855iso_chronisms
isolating1039745isolati_n___g
isolators947515isolat_o___rs
liberationist15124735liberationist_
nutritionists1393705nutritionists
operationisms1755095operationisms
operationist1457945operationist_
oppositionists18132865oppositionists
partitionists1554765partitionists
platonisms1466335__plat_onisms
projectionists2594115projectionists
protagonists1553685prota_gonists
protectionists18105145protectionists
receptionists1754775receptionists
recreationists1664375recreationists
reductionists1654655reductionists
relativists1464555_relati_vists
religionists1354395_religionists
reservationists1873695reservationists
revolutionises17154005revolutionises
revolutionist16106185revolutionist_
routinists1046095_ro_uti_nists
salvationism1763115_salvationis_m
satanists948235_s__at_anists
satirists958925_s__ati_rists
selectionist1458075_selectionist_
separationists1664085separationists
slalomists1283315_s_la_lomists
slatiness92511365_s_lati_nes_s
solation8916155_solation____
solipsists1252955_sol__ipsists
soloists869155_sol___o_ists
solutions988885_solution___s
solvations1336835_solvation___s
tobacconists1861035_tobacconists
vacationist1655905_vacationist_
violations1337965violation___s
violinists1344445viol__i_nists
vocationalists1964085_vocationalists
volatilises1454405_volati_lises

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.1401276364.3
2DLD Change Limit1247901178.48614705.4
3Display Results1171170.0761539.5
 (SQL Overall)1786911178.70220534.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.