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

48 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
sortition94670(None) 
sortitions1046421sortitions
partition1148692partition
sorption1037512sor_ption
attrition966963attrition
coalition1148703coalition
cognition1247013cognition
coition9314313co__ition
condition12411163condition
contrition12411413contrition
corotation12410973corotation
dentition1049633dentition
detrition1049133detrition
dotation91412733do_tation
formation1439423formation
fruition11106103_fruition
monition10311723mo_nition
mortician1346993mortician
notation81414603no_tation
nutrition966733nutrition
oration71617713_or_ation
partitions1248323partitions
perdition1249013perdition
petition10711753_petition
portion9615493por__tion
position10912193po_sition
postilion11117463postilion
potation101716783po_tation
rotation81615453ro_tation
saltation9312003saltation
satiation9313433s_atiation
sedition939333s_edition
seriation9318063seriation
serration9414063serration
siltation939213siltation
solation8916153so_lation
soliton7410233so_lit_on
solution889593so_lution
solvation1237773solvation
sorbitol1043743sorbit_ol
soritic91414433sor_iti_c
sorptions1137123sor_ptions
sortieing1046163sortieing
station72717243s__tation
stiction1038823s__tiction
striation9313483striation
striction1148983striction
volition1179173vo_lition

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.423422437.4
2DLD Change Limit148641487.78019105.5
3Display Results48480.0163000.0
 (SQL Overall)178691488.21921741.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.