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

65 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
arraigns94435(None) 
arraign845061arraign_
arraigned11103032arraigned
arraigner1092972arraigner
arraigners11142682arraigners
arranges939412arranges
deraigns1034882deraigns
abrasions1145813abrasions
acrasins1039973acrasins
aerations9317903aerations
agrarians1045793agrarians
airings83913843air_ings
aligns75312953a__ligns
arcadians1245083arcadians
arcadings1354393arcadings
archings14499863archings
armings103811503a_rmings
arracks1387733arra_cks
arraigning1242783arraigning
arrange838683arrang_e
arranged1036933arranged
arranger936883arranger
arrangers1045823arrangers
arranging1156303arranging
arrant6623253arra__nt
arras55626133arra___s
arrases71214543arra_ses
arrayals1154483arrayals
arrayers11125853arrayers
arraying1238753arraying
arrays95311683arra__ys
arris56824683arr_i__s
arrises71617583arr_ises
arrives101311513arr_ives
arshins10312573arshi_ns
assigns836193a_ssigns
attains7310983attai_ns
bargains1178643bargai_ns
barrages11711093barra_ges
barraging1337383barraging
brains85125473_brai_ns
campaigns1643473campaigns
carriages1238333carriages
carrions10312453carr_ions
coreigns1136323coreigns
deraign936573deraign_
drains73719403_drai_ns
earrings9299633earr_ings
grains74223093_grai_ns
larrigans1044013larr_igans
marriages1247383marriages
murrains1036853murrai_ns
narrations1038943narrations
ordains879653ordai_ns
rains55140233__rai_ns
reagins84215643_reagins
realigns936253_realigns
reigns74811753__reigns
resigns83910963_resigns
scraighs1443633scraighs
sprains93013593sprai_ns
strains74218153strai_ns
tarragons1044483tarragons
terrains8410323terrai_ns
trains64725343_trai_ns

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.440406115.9
2DLD Change Limit146162657.47019566.5
3Display Results65650.0302166.7
 (SQL Overall)178691657.94022505.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.