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

94 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
factualists165352(None) 
factualisms1853531factualisms
factualist1544751factualist_
factualism1753902factualis_m
factuality1843862factuali_ty
fatalists12310022fa_t_alists
actuality1445803_actuali_ty
actualizes2145903_actualizes
fabulists1444723fa_bu_lists
factualities1754533factualities
factualness1652993factualness
fantasists1385503fant_asists
fatalisms1439113fa_t_alisms
fatalist11314973fa_t_alist_
mutualists1244853_mutualists
naturalists1146443na_turalists
racialists1247703rac_ialists
ritualists1046173_ritualists
acquaints2042994_acqua_ints
activists1497044_act_ivists
actualities1346824_actualities
actualize2046354_actuali_ze
actualized2245344_actualized
actuaries1147574_actuari_es
actuations1239294_actuations
aerialists1089524_aerialists
animalists1258244_animalists
annalists949064_a_nnalists
aquarists1856124_a_quarists
arbalists1148484_a_rbalists
atavists1137584_a_t_avists
atonalists1048494_atonalists
backlists17117414bac__klists
cabalists1339154__cabalists
cabbalists1644724ca_bbalists
capitalists1555534capitalists
catalysts1445514ca_t_alysts
centralists1348144centralists
dualists958244___dualists
fabulist1347674fa_bu_list_
facelifts1742864fac__elifts
factionalisms20106364factionalisms
factual1246724factual____
factually1744664factual__ly
factualnesses1853694factualnesses
fantasises1395884fant_asises
fantasist1288004fant_asist_
fantasts1147114fant_a__sts
fatalism13310484fa_t_alis_m
fatalistic1546714fa_t_alistic
fatality1438444fa_t_ali_ty
fauvists1443844fa__u_vists
federalists1544754federalists
feudalists1454574f_eudalists
fictionists1655994fictionists
finalists123010164f__inalists
fiscalists1544674f_iscalists
focalises14139954foc__alises
formalists15217624f_ormalists
formulists15204704formu_lists
futurists1245584f_utu_rists
gradualists1352934gradualists
kabalists1546294ka__balists
kabbalists1843214ka_bbalists
localists11149794loc__alists
maximalists2253104maximalists
mentalists12410484ment_alists
metalists11412664_met_alists
mutualisms1444504_mutualisms
mutualist1146404_mutualist_
naturalises1146494na_turalises
naturalisms1346504na_turalisms
naturalist1048874na_turalist_
naturists947514na_tu_rists
neutralists11116644neutralists
obituarists1352344obituarists
oculists1037134_oc_u_lists
pastelists1245794past_elists
pastellists1353284pastellists
pastoralists1454954pastoralists
racialisms1447224rac_ialisms
racialist11411204rac_ialist_
recitalists1346504recitalists
ritualisms1246004_ritualisms
ritualist948644_ritualist_
satanists948234sa_t_anists
sensualists1154474sensualists
socialists1248494soc_ialists
tantalises101010104tant_alises
totalists9310754_tot_alists
visualists1344894_visualists
vitalists1239224_vit_alists
vocalists14108894voc__alists
waitlists1244604wait__lists

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 Filter1786911488190.420425454.8
2DLD Change Limit148819947.98618635.0
3Display Results94940.0462043.5
 (SQL Overall)178691948.45221141.9
 
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.