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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
filature114543(None) 
filatures1245861filatures
feature1039852f_eature
fixture1734962fi_xture
ligature945132ligature
arcature1086503arcature
armature10106973armature
cincture1245583cincture
cloture9238453_cloture
creature1038743creature
cubature1244693cubature
culture939393cul_ture
denature938073denature
dilatate947773dilatate
dilate73220693dilat__e
dilater83515653dilater_
dilaters92513063dilaters
dilative1239523dilative
dilator82712793dilator_
dilators93213203dilators
dilatory12279283dilatory
eglatere945163eglatere
facture12108933f_acture
failure1035753fail__ure
featured1237683f_eatured
features11310333f_eatures
fiacre1137623fi_a_cre
figure10258833fi__gure
filagree1295173filagree
filar84819293fila__r_
filaree10611213fila_ree
filariae1148473filariae
filiate10414233filiat__e
filter94517633fil_ter_
filtered12259043fil_tered
filterer11258143fil_terer
filters103816553fil_ters
finitude1244173finitude
fioratura1252243fioratura
fioraturae1351643fioraturae
fioriture1243043fioriture
fissure1036783fi_ssure
fixate1638733fixat__e
fixative2145083fixative
fixtures1835283fi_xtures
fixure16256543fi__xure
flare84823633f_la__re
flatter103815963f_latter
flatus94310783f_latu_s
flatuses1137173f_latuses
flatware1444893f_latware
flexure1743413f_lexure
folate93320393folat__e
fracture13147143fracture
future939563f__uture
immature1244443immature
ligatured1143333ligatured
ligatures1044933ligatures
mature8313473__mature
miniature1145263miniature
mixture1635413mi_xture
multure939183mul_ture
nature6311263__nature
ossature843303ossature
picture1158613pi_cture
plicature1344023plicature
prelature1146273prelature
renature839333renature
signature1053763signature
stature74410683_stature
tablature1143063tablature
tincture1044673tincture
vulture1036763vul_ture

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit146162737.51619446.8
3Display Results73730.0302433.3
 (SQL Overall)178691737.96922423.3
 
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.